Chapter 5. Working with Jet Databases and Tables

In this chapter

Understanding Jet Database Files

Creating a New Jet Database

Exploring the Properties of Tables and Fields

Choosing Field Data Types, Sizes, and Formats

Working with the Northwind Traders Sample Database

Preparing to Add a Table Related to the Employees Table

Designing the HRActions Table

Setting Default Values of Fields

Working with Relations, Key Fields, and Indexes

Altering Fields and Relationships

Working with Object Dependencies and Access Smart Tags

Copying and Pasting Tables

Using the Table Analyzer Wizard

Generating a Data Dictionary with the Database Documenter

Troubleshooting

In the Real World Database Strategy and Table Tactics



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net