Exploring Relational Database Design and Implementation
by Roger Jennings
Special Edition Using Access 97, Second Edition
- Copyright
- About the Author
- Acknowledgments
- Introduction
- Learning Access Fundamentals
- Access 97 for Access 95 and 2.0 Users: What's New
- Building Your First Access Application
- Navigating Within Acces
- Working with Access Databases and Tables
- Defining the Elements of Access Databases
- Understanding Relational Databases
- Using Access Database Files and Tables
- Creating a New Database
- Understanding the Properties of Tables and Fields
- Choosing Field Data Types, Sizes, and Formats
- Using the Northwind Traders Sample Database
- Setting Default Values of Fields
- Working with Relations, Key Fields, and Indexes
- Altering Fields and Relationships
- Copying and Pasting Tables
- Entering, Editing, and Validating Data in Tables
- Sorting, Finding, and Filtering Data in Tables
- Linking, Importing, and Exporting Tables
- Designing Queries
- Using Query by Example
- Understanding Operators and Expressions in Access
- Creating Multitable and Crosstab Queries
- Joining Tables to Create Multitable Queries
- Using Lookup Fields in Tables
- Outer, Self, and Theta Joins
- Updating Table Data with Queries
- Making All Fields of Tables Accessible
- Making Calculations on Multiple Records
- Designing Parameter Queries
- Creating Crosstab Queries
- Creating Queries from Tables in Other Databases
- Using Action Queries
- Creating Forms and Reports
- Creating and Using Forms
- Designing Custom Multitable Forms
- Printing Basic Reports and Mailing Labels
- Differences and Similarities Between Forms and Reports
- Types of Access Reports
- Creating a Grouping Report with the Report Wizard
- Using Access's Report Windows
- Using AutoFormat and Customizing Report Styles
- Modifying a Basic Report Wizard Report
- Adjusting Margins and Printing Conventional Reports
- Preventing Widowed Records with the Group Keep Together Property
- Printing Multicolumn Reports as Mailing Labels
- Preparing Advanced Reports
- Publishing Data on Intranets and the Internet
- Exporting Data to World Wide Web Pages
- Creating Dynamic Web Pages
- Integrating Access with Other Office 97 Applications
- Using Advanced Access Techniques
- Exploring Relational Database Design and Implementation
- Working with Structured Query Language
- Securing Multiuser Network Applications
- Networking Access Applications
- Installing Access in a Networked Environment
- Sharing Your Access Database Files with Other Users
- Using Command-Line Options to Open a Shared Database
- Maintaining Database Security
- Understanding Database Object Ownership
- Granting and Revoking Permissions for Database Objects
- Sharing Databases on the Network
- Administering Databases and Applications
- Connecting to Client/Server Databases
- Creating Scalable Access Applications
- Defining the Client/Server Environment
- Defining Open Database Connectivity
- Understanding ODBC Drivers
- Installing the Microsoft ODBC Driver for SQL Server
- Adding and Removing SQL Server Data Sources
- Using Databases Connected by ODBC
- Using Access 97's SQL Pass-Through Queries
- Exporting Access Tables to a Client/Server Database
- Programming and Converting Access Applicationys
- Writing Visual Basic for Applications Code
- Understanding the Data Access Object Class
- Responding to Events with VBA 5.0
- Programming Combo and List Boxes
- Working with Recordsets and Native Controls
- Exchanging Data with Automation and ActiveX Controls
- Migrating Access 2.0 and Access 95 Applications to Access 97
- Appendixes
Chapter 22. Exploring Relational Database Design and Implementation
You were introduced to a few of the elements of relational database design when you created the Personnel Actions table and joined it with the Employees table of the Northwind Traders database in Chapter 10, "Creating Multitable and Crosstab Queries." Chapter 20, "Using Access with Microsoft Excel," gave you a bit more insight into how to create a relational database from information contained in a worksheet. However, when you're presented with the challenge of designing a database from ground zero—especially a complex or potentially complex database—you need to understand the theory of relational database design and its terminology.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.