Absolute Beginner’s Guide to Databases

Chapter 5. Using Access to Build the Time Entry and Billing Database

CHAPTER HIGHLIGHTS:

• Automatically Generate the Database from the TEB Model

• A Brief Review of the Access Database Designer

• Use the Design to Create the Time Entry and Billing Database

• What You Have Learned

Now that you have completed your database model, it is time to create the physical database. There are two ways you can create the database. The first method generates the database automatically from the Visio diagram. The second method requires manual creation of all tables, fields, and relationships. Even with the automatic method, you will still have to manually set some field attributes. For this reason, this chapter will concentrate on the manual method. As a review, the ...