Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition
![Język publikacji: angielski Język publikacji: angielski](https://static01.helion.com.pl/global/flagi/1.png)
- Autor:
- PhD Steven Roman
![Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition PhD Steven Roman - okładka ebooka](https://static01.helion.com.pl/global/okladki/326x466/e_e04l.png)
![Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition PhD Steven Roman - tył okładki ebooka](https://static01.helion.com.pl/global/okladki-tyl/326x466/e_e04l.png)
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 450
- Dostępne formaty:
-
ePubMobi
Opis ebooka: Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition
Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas:
- Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data.
- Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
- Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets.
Wybrane bestsellery
-
Visual Basic .NET is a radically new version of Microsoft Visual Basic, the world's most widely used rapid application development (RAD) package. Whether you are just beginning application development with Visual Basic .NET or are already deep in code, you will appreciate just how easy and valuab...(20.20 zł najniższa cena z 30 dni)
19.89 zł
34.90 zł(-43%) -
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the bo...(92.74 zł najniższa cena z 30 dni)
92.24 zł
139.00 zł(-34%) -
This book simplifies IAM concepts to help you pass the SC-300 certification exam. Packed with practical examples, you’ll gain hands-on knowledge to drive strategic identity projects while modernizing identity solutions, implementing hybrid identity solutions, and monitoring identity govern...(121.87 zł najniższa cena z 30 dni)
121.37 zł
139.00 zł(-13%) -
Skuteczna nauka programu Microsoft Access 2013 Przekonaj się, jak łatwo i szybko możesz się nauczyć tworzyć własne bazy danych przy użyciu Microsoft Access 2013. Korzystając z książek serii Krok po kroku sam określasz tempo nabywania i utrwalania niezbędnych umiejętności, po prostu wtedy, kiedy s...(40.20 zł najniższa cena z 30 dni)
52.92 zł
58.80 zł(-10%) -
Ta książka, będąca kolejnym, przejrzanym i uaktualnionym wydaniem kultowego przewodnika po Accessie, jest odpowiednia dla użytkowników na wszystkich poziomach zaawansowania. Znalazły się tu wskazówki dotyczące podstaw baz danych, rozpoczynania pracy z Accessem, tworzenia własnych aplikacji bazoda...(107.40 zł najniższa cena z 30 dni)
107.40 zł
179.00 zł(-40%) -
Ta książka pomoże Ci w mig opanować obsługę Accessa 2016 PL. Dowiesz się z niej, dlaczego warto stworzyć swoją bazę danych, jak działa taka baza i jak wyglądają tabele. Odkryjesz, jak wpisywać i zmieniać dane, tworzyć połączenia między tabelami i konstruować zapytania podczas wyszukiwania konkret...(19.95 zł najniższa cena z 30 dni)
19.95 zł
39.90 zł(-50%) -
W tej książce znajdziesz wszystkie informacje pozwalające na utworzenie i skonfigurowanie bazy danych, a także je podstawowych obiektów, czyli tabel. Odkryjesz, na czym polega genialny pomysł z relacyjnością bazy danych, i nauczysz się ustanawiać relacje między obiektami. Dowiesz się także, jak p...(14.95 zł najniższa cena z 30 dni)
14.95 zł
29.90 zł(-50%) -
Keystone—OpenStack's Identity service—provides secure controlled access to a cloud’s resources. In OpenStack environments, Keystone performs many vital functions, such as authenticating users and determining what resources users are authorized to access.Whether the cloud is priv...(51.42 zł najniższa cena z 30 dni)
51.24 zł
89.90 zł(-43%) -
Książka Access 2007 PL w biurze i nie tylko to świetny przewodnik po strukturze tej aplikacji, gwarantujący efektywne przyswojenie wiedzy na temat zakładania bazy danych i korzystania z niej. Dowiesz się stąd, jak rozpocząć pracę z programem i gdzie szukać potrzebnych narzędzi. Nauczysz się tworz...(29.49 zł najniższa cena z 30 dni)
29.49 zł
59.00 zł(-50%) -
Krok po kroku wprowadzi Cię ona w świat baz danych, przedstawi podstawowe pojęcia, niezbędne do zrozumienia modelu relacyjnego, zaprezentuje interfejs programu Access oraz pokaże, jak za jego pomocą zaprojektować i utworzyć bazę, zarządzać nią i wypełnić ją danymi. Nauczy Cię w praktyce korzystać...(38.50 zł najniższa cena z 30 dni)
38.50 zł
77.00 zł(-50%)
Ebooka "Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- ISBN Ebooka:
- 978-14-493-6643-8, 9781449366438
- Data wydania ebooka:
-
2002-01-07
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 2.0MB
- Rozmiar pliku Mobi:
- 2.0MB
Spis treści ebooka
- Access Database Design & Programming, 3rd Edition
- A Note Regarding Supplemental Files
- Preface
- Preface to the Third Edition
- Preface to the Second Edition
- The Books Audience
- The Sample Code
- Organization of This Book
- Part I
- Part II
- Part III
- Part IV
- Part V
- Part VI
- Part VII
- Part VIII
- Conventions in This Book
- Obtaining Updated Information
- Using Code Examples
- Request for Comments
- Acknowledgments
- I. Database Design
- 1. Introduction
- 1.1. Database Design
- 1.1.1. Why Use a Relational-Database Design?
- 1.1.1.1. Redundancy
- 1.1.1.2. Multiple-value problems
- 1.1.1.3. Update anomalies
- 1.1.1.4. Insertion anomalies
- 1.1.1.5. Deletion anomalies
- 1.1.1. Why Use a Relational-Database Design?
- 1.1.2. Complications of Relational-Database Design
- 1.1.2.1. Avoiding data loss
- 1.1.2.2. Maintaining relational integrity
- 1.1.2.3. Creating views
- 1.1. Database Design
- 1.1.3. Summary
- 1. Introduction
- 1.2. Database Programming
- 2. The Entity-Relationship Model of a Database
- 2.1. What Is a Database?
- 2.2. Entities and Their Attributes
- 2.3. Keys and Superkeys
- 2.4. Relationships Between Entities
- 2.4.1. Types of Relationships
- 3. Implementing Entity-Relationship Models: Relational Databases
- 3.1. Implementing Entities
- 3.1.1. Implementing Entity ClassesTable Schemes
- 3.1.2. Implementing Entity SetsTables
- 3.1. Implementing Entities
- 3.2. A Short Glossary
- 3.3. Implementing the Relationships in a Relational Database
- 3.3.1. Implementing a One-to-Many RelationshipForeign Keys
- 3.3.2. Implementing a One-to-One Relationship
- 3.3.3. Implementing a Many-to-Many RelationshipNew Entity Classes
- 3.3.4. Referential Integrity
- 3.3.5. Cascading Updates and Cascading Deletions
- 3.4. The LIBRARY Relational Database
- 3.4.1. Setting Up the Relationships in Access
- 3.5. Index Files
- 3.5.1. Example
- 3.6. NULL Values
- 4. Database Design Principles
- 4.1. Redundancy
- 4.2. Normal Forms
- 4.3. First Normal Form
- 4.4. Functional Dependencies
- 4.5. Second Normal Form
- 4.6. Third Normal Form
- 4.7. Boyce-Codd Normal Form
- 4.8. Normalization
- 4.8.1. Decomposition
- II. Database Queries
- 5. Query Languages and the Relational Algebra
- 5.1. Query Languages
- 5.2. Relational Algebra and Relational Calculus
- 5.3. Details of the Relational Algebra
- 5.3.1. Renaming
- 5.3.2. Union
- 5.3.3. Intersection
- 5.3.4. Difference
- 5.3.5. Cartesian Product
- 5.3.6. Projection
- 5.3.7. Selection
- 5.3.8. Joins
- 5.3.8.1. Equi-join
- 5.3.8.2. Natural join
- 5.3.8.3. -Join
- 5.3.9. Outer Joins
- 5.3.10. Implementing Joins in Microsoft Access
- 5.3.11. Semi-Joins
- 5.3.12. Other Relational Algebra Operations
- 5.3.13. Optimization
- 5. Query Languages and the Relational Algebra
- 6. Access Structured Query Language (SQL)
- 6.1. Introduction to Access SQL
- 6.2. Access Query Design
- 6.3. Access Query Types
- 6.4. Why Use SQL?
- 6.5. Access SQL
- 6.5.1. Syntax Conventions
- 6.5.1.1. Notes
- 6.5.1. Syntax Conventions
- 6.6. The DDL Component of Access SQL
- 6.6.1. The CREATE TABLE Statement
- 6.6.1.1. Column definition
- 6.6.1.2. Constraints
- 6.6.1.3. Notes
- 6.6.1. The CREATE TABLE Statement
- 6.6.2. The ALTER TABLE Statement
- 6.6.2.1. Notes
- 6.6.3. The CREATE INDEX Statement
- 6.6.3.1. Note
- 6.6.4. The DROP Statement
- 6.6.4.1. Note
- 6.7. The DML Component of Access SQL
- 6.7.1. Updatable Queries
- 6.7.2. Joins
- 6.7.2.1. Inner joins
- 6.7.2.2. Outer joins
- 6.7.2.3. Nested joins
- 6.7.2.4. Self-joins
- 6.7.2.5. Notes
- 6.7.3. The SELECT Statement
- 6.7.3.1. Predicate
- 6.7.3.2. ReturnColumnDescription
- 6.7.3.3. FROM TableExpression
- 6.7.3.4. WHERE RowCondition
- 6.7.3.5. GROUP BY GroupByCriteria
- 6.7.3.6. HAVING GroupCriteria
- 6.7.3.7. ORDER BY OrderByCriteria
- 6.7.4. The UNION Statement
- 6.7.4.1. Example
- 6.7.4.2. Notes
- 6.7.5. The UPDATE Statement
- 6.7.5.1. Example
- 6.7.6. The DELETE Statement
- 6.7.7. The INSERT INTO Statement
- 6.7.7.1. Note
- 6.7.8. The SELECT...INTO Statement
- 6.7.8.1. Notes
- 6.7.9. TRANSFORM
- 6.7.10. Subqueries
- 6.7.10.1. Syntax 1
- 6.7.10.2. Syntax 2
- 6.7.10.3. Syntax 3
- 6.7.10.4. Notes
- 6.7.11. Parameters
- III. Database Architecture
- 7. Database System Architecture
- 7.1. Why Program?
- 7.2. Database Systems
- 7.3. Database Management Systems
- 7.4. The Jet DBMS
- 7.5. Data Definition Languages
- 7.5.1. The Jet Data Definition Language
- 7.6. Data Manipulation Languages
- 7.6.1. The Jet Data Manipulation Language
- 7. Database System Architecture
- 7.7. Host Languages
- 7.8. The Client/Server Architecture
- IV. Visual Basic for Applications
- 8. The Visual Basic Editor, Part I
- 8.1. The Project Window
- 8.1.1. Project Names
- 8.1.2. Project Contents
- 8.1.2.1. Standard modules
- 8.1.2.2. Class modules
- 8.1. The Project Window
- 8.2. The Properties Window
- 8.3. The Code Window
- 8.3.1. Procedure and Full-Module Views
- 8.3.2. The Object and Procedure Listboxes
- 8. The Visual Basic Editor, Part I
- 8.4. The Immediate Window
- 8.5. Arranging Windows
- 8.5.1. Docking
- 9. The Visual Basic Editor, Part II
- 9.1. Navigating the IDE
- 9.1.1. General Navigation
- 9.1.1.1. Navigating the code window at design time
- 9.1.1.2. Tracing code
- 9.1.1.3. Bookmarks
- 9.1.1. General Navigation
- 9.1. Navigating the IDE
- 9.2. Getting Help
- 9.3. Creating a Procedure
- 9.4. Run Mode, Break Mode, and Design Mode
- 9.5. Errors
- 9.5.1. Design-Time and Compile-Time Errors
- 9.5.2. Runtime Errors
- 9.5.3. Logical Errors
- 9.6. Debugging
- 9.6.1. Tracing
- 9.6.1.1. Step Into (F8 or choose Step Into from the Debug menu)
- 9.6.1.2. Step Over (Shift+F8 or choose Step Over from the Debug menu)
- 9.6.1.3. Step Out (Ctrl+Shift+F8 or choose Step Out from the Debug menu)
- 9.6.1.4. Run to Cursor (Ctrl+F8 or choose Run To Cursor from the Debug menu)
- 9.6.1.5. Set Next Statement (Ctrl+F9 or choose Set Next Statement from the Debug menu)
- 9.6.1.6. Breaking out of Debug mode
- 9.6.1. Tracing
- 10. Variables, Data Types, and Constants
- 10.1. Comments
- 10.2. Line Continuation
- 10.3. Constants
- 10.3.1. Enums
- 10.4. Variables and Data Types
- 10.4.1. Variable Declaration
- 10.4.2. The Importance of Explicit Variable Declaration
- 10.4.2.1. Option Explicit
- 10.4.3. Numeric Data Types
- 10.4.4. Boolean Data Type
- 10.4.5. String Data Type
- 10.4.6. Date Data Type
- 10.4.7. Variant Data Type
- 10.4.8. Access Object Data Types
- 10.4.8.1. The generic As Object declaration
- 10.4.8.2. The Set statement
- 10.4.9. Arrays
- 10.4.9.1. The dimension of an array
- 10.4.9.2. Dynamic arrays
- 10.4.9.3. The UBound function
- 10.4.10. Variable Naming Conventions
- 10.4.11. Variable Scope
- 10.4.11.1. Procedure-level (local) variables
- 10.4.11.2. Module-level variables
- 10.4.12. Variable Lifetime
- 10.4.12.1. Static variables
- 10.4.13. Variable Initialization
- 10.5. VBA Operators
- 11. Functions and Subroutines
- 11.1. Calling Functions
- 11.2. Calling Subroutines
- 11.3. Parameters and Arguments
- 11.3.1. Optional Arguments
- 11.3.2. Named Arguments
- 11.3.3. ByRef Versus ByVal Parameters
- 11.4. Exiting a Procedure
- 11.5. Public and Private Procedures
- 11.6. Fully Qualified Procedure Names
- 12. Built-in Functions and Statements
- 12.1. The MsgBox Function
- 12.2. The InputBox Function
- 12.3. VBA String Functions
- 12.4. Miscellaneous Functions and Statements
- 12.4.1. The Is Functions
- 12.4.1.1. The IsDate function
- 12.4.1.2. The IsEmpty function
- 12.4.1.3. The IsNull function
- 12.4.1.4. The IsNumeric function
- 12.4.1. The Is Functions
- 12.4.2. The Immediate If Function
- 12.4.3. The Switch Function
- 12.4.4. The Beep Statement
- 12.5. Handling Errors in Code
- 12.5.1. The On Error Goto Label Statement
- 12.5.2. Handling Errors in the Calling Procedure
- 12.5.3. The Calls Stack
- 12.5.4. The Error Object
- 12.5.5. The On Error GoTo 0 Statement
- 12.5.6. The On Error Resume Next Statement
- 12.5.7. The Resume Statement
- 13. Control Statements
- 13.1. The If ...Then Statement
- 13.2. The For Loop
- 13.3. The Exit For Statement
- 13.4. The For Each Loop
- 13.5. The Do Loop
- 13.6. The Select Case Statement
- 13.7. A Final Note on VBA
- 13.7.1. File-Related Functions
- 13.7.2. Date- and Time-Related Functions
- 13.7.3. The Format Function
- V. Data Access Objects
- 14. Programming DAO: Overview
- 14.1. Objects
- 14.1.1. Object Variables
- 14.1.2. Object-Variable Naming Conventions
- 14.1.3. Referencing the Properties and Methods of an Object
- 14.1. Objects
- 14.2. The DAO Object Model
- 14.3. The Microsoft Access Object Model
- 14.4. Referencing Objects
- 14.4.1. Fully Qualified Object Names
- 14.4.2. Using Object Variables to Your Advantage
- 14.4.3. Default Collections
- 14. Programming DAO: Overview
- 14.5. Collections Are Objects Too
- 14.5.1. Properties and Methods of Access Collections
- 14.5.2. Properties and Methods of DAO Collections
- 14.5.3. Properties and Methods of User-Defined Collections
- 14.5.4. Say It Again
- 14.5.5. Refreshing Certain Collections
- 14.6. The Properties Collection
- 14.6.1. The Virtues of Properties Collections
- 14.6.2. Types of Properties
- 14.6.2.1. Property: Inherited
- 14.6.2.2. Property: Name
- 14.6.2.3. Property: Type
- 14.6.2.4. Property: Value
- 14.6.3. User-Defined Properties
- 14.7. Closing DAO Objects
- 14.8. A Look at the DAO Objects
- 14.8.1. DBEngine Object
- 14.8.2. Errors
- 14.8.3. Workspaces
- 14.8.4. Users
- 14.8.5. Groups
- 14.8.6. Databases
- 14.8.7. TableDefs
- 14.8.8. QueryDefs
- 14.8.9. Recordsets
- 14.8.10. Relations
- 14.8.11. Containers
- 14.8.12. Documents
- 14.8.13. Fields
- 14.8.14. Parameters
- 14.8.15. Indexes
- 14.9. The CurrentDb Function
- 15. Programming DAO: Data Definition Language
- 15.1. Creating a Database
- 15.1.1. Notes
- 15.1. Creating a Database
- 15.2. Opening a Database
- 15.3. Creating a Table and Its Fields
- 15.3.1. Notes
- 15.3.1.1. Note
- 15.3.1. Notes
- 15.3.2. Changing the Properties of an Existing Table or Field
- 15.4. Creating an Index
- 15.5. Creating a Relation
- 15.5.1. Notes
- 15.6. Creating a QueryDef
- 15.6.1. Notes
- 15.6.2. Running a Query
- 15.6.3. Properties of a QueryDef Object
- 16. Programming DAO: Data Manipulation Language
- 16.1. Recordset Objects
- 16.2. Opening a Recordset
- 16.2.1. Note
- 16.2.2. Default Recordset Types
- 16.3. Moving Through a Recordset
- 16.3.1. BOF and EOF
- 16.3.1.1. Notes on the BOF and EOF properties
- 16.3.1.2. Notes on the Move methods
- 16.3.1. BOF and EOF
- 16.4. Finding Records in a Recordset
- 16.4.1. Finding Records in a Table-Type Recordset
- 16.4.1.1. Notes
- 16.4.1. Finding Records in a Table-Type Recordset
- 16.4.2. Finding Records in a Dynaset-Type or Snapshot-Type Recordset
- 16.5. Editing Data Using a Recordset
- 16.5.1. Editing an Existing Record
- 16.5.2. Deleting an Existing Record
- 16.5.2.1. Notes
- 16.5.3. Adding a New Record
- 16.5.3.1. Notes
- VI. ActiveX Data Objects
- 17. ADO and OLE DB
- 17.1. What Is ADO?
- 17.2. Installing ADO
- 17.3. ADO and OLE DB
- 17.3.1. Data Stores
- 17.3.2. Data Providers
- 17.3.3. Data Consumers
- 17.3.4. Service Providers
- 17.4. The ADO Object Model
- 17.4.1. The Three-Pronged Approach to Data Manipulation
- 17.4.2. The Connection Object
- 17.4.2.1. Properties of the Connection object
- 17.4.2.2. Methods of the Connection object
- 17.4.3. The Recordset Object
- 17.4.3.1. Cursors
- 17.4.3.2. LockType
- 17.4.3.3. Properties of the Recordset object
- 17.4.3.4. Methods of the Recordset object
- 17. ADO and OLE DB
- 17.4.4. The Command Object
- 17.4.4.1. Command objects and connections
- 17.4.4.2. Properties of the Command object
- 17.4.4.3. Methods of the Command object
- 17.4.5. The Property Object and Dynamic Properties
- 17.4.6. The Field Object
- 17.4.6.1. Properties of the Field object
- 17.5. Finding OLE DB Providers
- 17.6. A Closer Look at Connection Strings
- 17.6.1. The Microsoft Jet 3.51 OLE DB Provider
- 17.6.2. The Microsoft OLE DB Provider for ODBC Drivers
- 17.6.2.1. Connecting to an Excel workbook
- 17.6.2.2. Connecting to a text file
- 17.6.2.3. ODBC support
- 17.7. An Example: Using ADO over the Web
- 18. ADOX: Jet Data Definition in ADO
- 18.1. The ADOX Object Model
- 18.1.1. Creating a Database
- 18.1.2. Creating Tables
- 18.1.3. The Tables Collection
- 18.1.4. Creating Indexes
- 18.1.5. Creating a Primary Key
- 18.1.6. Creating a Query
- 18.1.7. Conclusion
- 18.1. The ADOX Object Model
- VII. Programming Problems
- 19. Some Common Data Manipulation Problems
- 19.1. Running Sums
- 19.1.1. Solution
- 19.1. Running Sums
- 19.2. Overlapping Intervals I
- 19.2.1. Solution
- 19. Some Common Data Manipulation Problems
- 19.3. Overlapping Intervals II
- 19.3.1. Solution
- 19.4. Making Assignments with Default
- 19.4.1. Solution
- 19.5. Time to Completion I
- 19.5.1. Solution
- 19.6. Time to Completion II
- 19.6.1. Solution
- 19.7. Time to Completion IIIA MaxMin Problem
- 19.7.1. Solution 1
- 19.7.2. Solution 2
- 19.8. Vertical to Horizontal
- 19.8.1. Solution
- 19.9. A Matching Problem
- 19.9.1. Solution
- 19.10. Equality of Sets
- 19.10.1. Solution
- VIII. Appendixes
- A. DAO 3.0/3.5 Collections, Properties, and Methods
- A.1. DAO Classes
- A.2. A Collection Object
- A.2.1. Methods
- A.2.2. Properties
- A.2.3. Methods
- A.3. Connection Object (DAO 3.5 Only)
- A.3.1. Collections
- A.3.2. Methods
- A.3.3. Properties
- A. DAO 3.0/3.5 Collections, Properties, and Methods
- A.4. Container Object
- A.4.1. Collections
- A.4.2. Properties
- A.5. Database Object
- A.5.1. Collections
- A.5.2. Methods
- A.5.3. Properties
- A.6. DBEngine Object
- A.6.1. Collections
- A.6.2. Methods
- A.6.3. Properties
- A.7. Document Object
- A.7.1. Methods
- A.7.2. Properties
- A.8. Error Object
- A.8.1. Properties
- A.9. Field Object
- A.9.1. Collections
- A.9.2. Methods
- A.9.3. Properties
- A.10. Group Object
- A.10.1. Collections
- A.10.2. Methods
- A.10.3. Properties
- A.11. Index Object
- A.11.1. Collections
- A.11.2. Methods
- A.11.3. Properties
- A.12. Parameter Object
- A.12.1. Properties
- A.13. Property Object
- A.13.1. Properties
- A.14. QueryDef Object
- A.14.1. Collections
- A.14.2. Methods
- A.14.3. Properties
- A.15. Recordset Object
- A.15.1. Collections
- A.15.2. Methods
- A.15.3. Properties
- A.16. Relation Object
- A.16.1. Collections
- A.16.2. Methods
- A.16.3. Properties
- A.17. TableDef Object
- A.17.1. Collections
- A.17.2. Methods
- A.17.3. Properties
- A.18. User Object
- A.18.1. Collections
- A.18.2. Methods
- A.18.3. Properties
- A.19. Workspace Object
- A.19.1. Collections
- A.19.2. Methods
- A.19.3. Properties
- B. The Quotient: An Additional Operation of the Relational Algebra
- B.1. Step 1
- B.2. Step 2
- B.3. Step 3
- C. Open Database Connectivity (ODBC)
- C.1. Introduction
- C.2. The ODBC Driver Manager
- C.3. The ODBC Driver
- C.3.1. Driver Types
- C.4. Data Sources
- C.4.1. DSNs and Data Source Types
- C.4.1.1. Machine data sources
- C.4.1.2. File data sources
- C.4.1. DSNs and Data Source Types
- C.4.2. Creating DSNs: The ODBC Administrator
- C.4.3. Example DSNs
- C.4.3.1. Excel system data source
- C.4.3.2. Excel file data source
- C.4.3.3. Text-system data source
- C.4.4. Connecting to a Data Source
- C.4.5. The SQLConnect Function
- C.4.6. Connection Strings
- C.4.7. SQLDriverConnect
- C.5. Getting ODBC Driver Help
- C.6. Getting ODBC Information Using Visual Basic
- C.6.1. Preliminaries
- C.6.2. Getting Driver Information
- C.6.3. Getting Data Sources
- D. Obtaining or Creating the Sample Database
- D.1. Creating the Database
- D.2. Creating the BOOKS Table
- D.3. Creating the AUTHORS Table
- D.4. Creating the PUBLISHERS Table
- D.5. Creating the BOOK/AUTHOR Table
- D.6. Backing Up the Database
- D.7. Entering and Running the Sample Programs
- E. Suggestions for Further Reading
- Index
- Colophon
- Copyright
O'Reilly Media - inne książki
-
This concise yet comprehensive guide explains how to adopt a data lakehouse architecture to implement modern data platforms. It reviews the design considerations, challenges, and best practices for implementing a lakehouse and provides key insights into the ways that using a lakehouse can impact ...(193.19 zł najniższa cena z 30 dni)
192.69 zł
249.00 zł(-23%) -
In today's fast-paced world, more and more organizations require rapid application development with reduced development costs and increased productivity. This practical guide shows application developers how to use PowerApps, Microsoft's no-code/low-code application framework that helps developer...(162.27 zł najniższa cena z 30 dni)
162.17 zł
209.00 zł(-22%) -
Welcome to the systems age, where software professionals are no longer building software&emdash;we're building systems of software. Change is continuously deployed across software ecosystems coordinated by responsive infrastructure. In this world of increasing relational complexity, we need t...(152.01 zł najniższa cena z 30 dni)
151.81 zł
209.00 zł(-27%) -
This book provides an ideal guide for Python developers who want to learn how to build applications with large language models. Authors Olivier Caelen and Marie-Alice Blete cover the main features and benefits of GPT-4 and GPT-3.5 models and explain how they work. You'll also get a step-by-step g...(155.36 zł najniższa cena z 30 dni)
154.86 zł
209.00 zł(-26%) -
In today's cloud native world, where we automate as much as possible, everything is code. With this practical guide, you'll learn how Policy as Code (PaC) provides the means to manage the policies, related data, and responses to events that occur within the systems we maintain—Kubernetes, c...(212.39 zł najniższa cena z 30 dni)
212.34 zł
279.00 zł(-24%) -
Geared to intermediate- to advanced-level DBAs and IT professionals looking to enhance their MySQL skills, this guide provides a comprehensive overview on how to manage and optimize MySQL databases. You'll learn how to create databases and implement backup and recovery, security configurations, h...(221.33 zł najniższa cena z 30 dni)
221.28 zł
279.00 zł(-21%) -
Get the details, examples, and best practices you need to build generative AI applications, services, and solutions using the power of Azure OpenAI Service. With this comprehensive guide, Microsoft AI specialist Adrián González Sánchez examines the integration and utilization of Az...(162.18 zł najniższa cena z 30 dni)
162.08 zł
209.00 zł(-22%) -
Despite the increase of high-profile hacks, record-breaking data leaks, and ransomware attacks, many organizations don't have the budget for an information security (InfoSec) program. If you're forced to protect yourself by improvising on the job, this pragmatic guide provides a security-101 hand...(214.57 zł najniższa cena z 30 dni)
214.47 zł
239.00 zł(-10%) -
Keeping up with the Python ecosystem can be daunting. Its developer tooling doesn't provide the out-of-the-box experience native to languages like Rust and Go. When it comes to long-term project maintenance or collaborating with others, every Python project faces the same problem: how to build re...(188.79 zł najniższa cena z 30 dni)
188.29 zł
239.00 zł(-21%) -
Bringing a deep-learning project into production at scale is quite challenging. To successfully scale your project, a foundational understanding of full stack deep learning, including the knowledge that lies at the intersection of hardware, software, data, and algorithms, is required.This book il...(227.14 zł najniższa cena z 30 dni)
226.64 zł
279.00 zł(-19%)
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
![Loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
![ajax-loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
Oceny i opinie klientów: Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition PhD Steven Roman (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.