Access Database Design and Programming

ISBN-10: 0596002734
ISBN-13: 9780596002732
Edition: 3rd 2002
List price: $39.99 Buy it from $2.39
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: "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  More...

New Starting from $30.04
eBooks Starting from $31.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
History of Western Art Online content $4.95 $1.99
Add to cart
Study Briefs
History of World Philosophies Online content $4.95 $1.99
Add to cart
Study Briefs
American History Volume 1 Online content $4.95 $1.99
Add to cart
Study Briefs
History of Western Music Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 3rd
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 1/17/2002
Binding: Paperback
Pages: 430
Size: 7.25" wide x 9.00" long x 1.00" tall
Weight: 1.540
Language: English

"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. Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, "Access Database Design & Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This bookalso serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.

Steven Roman, Ph.D., is a professor emeritus of mathematics at the California State University, Fullerton. His previous books with O'Reilly include "Access Database Design and Programming", "Writing Excel Macros with VBA", and "Win32 API Programming with Visual Basic".

Preface
Database Design
Introduction
Database Design
Database Programming
The Entity-Relationship Model of a Database
What Is a Database?
Entities and Their Attributes
Keys and Superkeys
Relationships Between Entities
Implementing Entity-Relationship Models: Relational Databases
Implementing Entities
A Short Glossary
Implementing the Relationships in a Relational Database
The LIBRARY Relational Database
Index Files
NULL Values
Database Design Principles
Redundancy
Normal Forms
First Normal Form
Functional Dependencies
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
Normalization
Database Queries
Query Languages and the Relational Algebra
Query Languages
Relational Algebra and Relational Calculus
Details of the Relational Algebra
Access Structured Query Language (SQL)
Introduction to Access SQL
Access Query Design
Access Query Types
Why Use SQL?
Access SQL
The DDL Component of Access SQL
The DML Component of Access SQL
Database Architecture
Database System Architecture
Why Program?
Database Systems
Database Management Systems
The Jet DBMS
Data Definition Languages
Data Manipulation Languages
Host Languages
The Client/Server Architecture
Visual Basic for Applications
The Visual Basic Editor
The Project Window
The Properties Window
The Code Window
The Immediate Window
Arranging Windows
The Visual Basic Editor, Part II
Navigating the IDE
Getting Help
Creating a Procedure
Run Mode, Break Mode, and Design Mode
Errors
Debugging
Variables, Data Types, and Constants
Comments
Line Continuation
Constants
Variables and Data Types
VBA Operators
Functions and Subroutines
Calling Functions
Calling Subroutines
Parameters and Arguments
Exiting a Procedure
Public and Private Procedures
Fully Qualified Procedure Names
Built-in Functions and Statements
The MsgBox Function
The InputBox Function
VBA String Functions
Miscellaneous Functions and Statements
Handling Errors in Code
Control Statements
The If...Then Statement
The For Loop
The Exit For Statement
The For Each Loop
The Do Loop
The Select Case Statement
A Final Note on VBA
Data Access Objects
Programming DAO: Overview
Objects
The DAO Object Model
The Microsoft Access Object Model
Referencing Objects
Collections Are Objects Too
The Properties Collection
Closing DAO Objects
A Look at the DAO Objects
The CurrentDb Function
Programming DAO: Data Definition Language
Creating a Database
Opening a Database
Creating a Table and Its Fields
Creating an Index
Creating a Relation
Creating a QueryDef
Programming DAO: Data Manipulation Language
Recordset Objects
Opening a Recordset
Moving Through a Recordset
Finding Records in a Recordset
Editing Data Using a Recordset
ActiveX Data Objects
ADO and OLE DB
What Is ADO?
Installing ADO
ADO and OLE DB
The ADO Object Model
Finding OLE DB Providers
A Closer Look at Connection Strings
An Example: Using ADO over the Web
ADOX: Jet Data Definition in ADO
The ADOX Object Model
Programming Problems
Some Common Data Manipulation Problems
Running Sums
Overlapping Intervals I
Overlapping Intervals II
Making Assignments with Default
Time to Completion I
Time to Completion II
Time to Completion III--A MaxMin Problem
Vertical to Horizontal
A Matching Problem
Equality of Sets
Appendixes
DAO 3.0/3.5 Collections, Properties, and Methods
The Quotient: An Additional Operation of the Relational Algebra
Open Database Connectivity (ODBC)
Obtaining or Creating the Sample Database
Suggestions for Further Reading
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×