Use the Design to Create the Time Entry and Billing Database

This section will go through, step-by-step, how to create tables, columns, and relationships. Chapter 2 gave you the 10,000-foot view on the Access design tools. Now, you are going to see and experience how these tools work through actual practice. The process will start with the creation of an empty database. After the database has been created, you will then create the tables. Within each table, you will define the columns, the attributes for each column, and the primary key. After the tables have been constructed, the relationships between the tables will be defined. After these tasks have been completed, the Time Entry and Billing Database core components will be complete. You ...

Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.