• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Working with Access Databases... > Adding a New Table to an Existing Da...

Adding a New Table to an Existing Database

The Northwind Traders database includes an Employees table that provides most of the information about the firm's employees that is typical of personnel tables. The following sections explain how to add a table called Personnel Actions to the database. The Personnel Actions table is a record of hire date, salary, commission rate, bonuses, performance reviews, and other compensation-related events for employees. Because Personnel Actions is based on information in the Employees table, the first step is to review the Employees table's structure to see how you can use it with your new table. Table structure is displayed in design mode. In the next chapter, "Entering, Editing, and Validating Data in Tables," you add validation rules to the Personnel Actions table and enter records in the table.

To open the Employees table in design mode, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint