Access Database Design & Programming. Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003. 3rd Edition
- Autor:
- PhD Steven Roman
- 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...(29.67 zł najniższa cena z 30 dni)
29.67 zł
34.90 zł(-15%) -
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...(118.15 zł najniższa cena z 30 dni)
118.15 zł
139.00 zł(-15%) -
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...
Microsoft Identity and Access Administrator Exam Guide. Implement IAM solutions with Azure AD, build an identity governance strategy, and pass the SC-300 exam Microsoft Identity and Access Administrator Exam Guide. Implement IAM solutions with Azure AD, build an identity governance strategy, and pass the SC-300 exam
-
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...(52.92 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...(116.35 zł najniższa cena z 30 dni)
125.30 zł
179.00 zł(-30%) -
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)
21.95 zł
39.90 zł(-45%) -
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)
16.45 zł
29.90 zł(-45%) -
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...
Identity, Authentication, and Access Management in OpenStack. Implementing and Deploying Keystone Identity, Authentication, and Access Management in OpenStack. Implementing and Deploying Keystone
(80.73 zł najniższa cena z 30 dni)80.73 zł
94.99 zł(-15%) -
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)
32.45 zł
59.00 zł(-45%) -
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)
42.35 zł
77.00 zł(-45%)
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
-
Software as a service (SaaS) is on the path to becoming the de facto model for building, delivering, and operating software solutions. Adopting a multi-tenant SaaS model requires builders to take on a broad range of new architecture, implementation, and operational challenges. How data is partiti...(237.15 zł najniższa cena z 30 dni)
245.65 zł
289.00 zł(-15%) -
Great engineers don't necessarily make great leaders—at least, not without a lot of work. Finding your path to becoming a strong leader is often fraught with challenges. It's not easy to figure out how to be strategic, successful, and considerate while also being firm. Whether you're on the...(126.65 zł najniższa cena z 30 dni)
126.65 zł
149.00 zł(-15%) -
Data science happens in code. The ability to write reproducible, robust, scaleable code is key to a data science project's success—and is absolutely essential for those working with production code. This practical book bridges the gap between data science and software engineering,and clearl...(211.65 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
With the massive adoption of microservices, operators and developers face far more complexity in their applications today. Service meshes can help you manage this problem by providing a unified control plane to secure, manage, and monitor your entire network. This practical guide shows you how th...(203.15 zł najniższa cena z 30 dni)
203.15 zł
239.00 zł(-15%) -
Get practical advice on how to leverage AI development tools for all stages of code creation, including requirements, planning, design, coding, debugging, testing, and documentation. With this book, beginners and experienced developers alike will learn how to use a wide range of tools, from gener...(164.25 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
Rust's popularity is growing, due in part to features like memory safety, type safety, and thread safety. But these same elements can also make learning Rust a challenge, even for experienced programmers. This practical guide helps you make the transition to writing idiomatic Rust—while als...(164.25 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
Advance your Power BI skills by adding AI to your repertoire at a practice level. With this practical book, business-oriented software engineers and developers will learn the terminologies, practices, and strategy necessary to successfully incorporate AI into your business intelligence estate. Je...(211.65 zł najniższa cena z 30 dni)
211.65 zł
249.00 zł(-15%) -
Microservices can be a very effective approach for delivering value to your organization and to your customers. If you get them right, microservices help you to move fast by making changes to small parts of your system hundreds of times a day. But if you get them wrong, microservices will just ma...(203.15 zł najniższa cena z 30 dni)
203.15 zł
239.00 zł(-15%) -
JavaScript gives web developers great power to create rich interactive browser experiences, and much of that power is provided by the browser itself. Modern web APIs enable web-based applications to come to life like never before, supporting actions that once required browser plug-ins. Some are s...(186.15 zł najniższa cena z 30 dni)
186.15 zł
219.00 zł(-15%) -
How will software development and operations have to change to meet the sustainability and green needs of the planet? And what does that imply for development organizations? In this eye-opening book, sustainable software advocates Anne Currie, Sarah Hsu, and Sara Bergman provide a unique overview...(169.14 zł najniższa cena z 30 dni)
169.14 zł
199.00 zł(-15%)
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
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.