Enter Names into a Database

In Application 4-2, you practiced using alphabetic indexing rules 5-8 to file names that would appear on physical documents

In this application, you will use the same names in an electronic database. To compare the results of the two methods, you will enter the names as written (the filing segment) and by filing units.

1. new Access database file named "4-4 Customers."

2. table in the database named "Customers." Create these fields in the table: ID Number, Filing Segment, Key Unit, Unit 2, Unit 3, Unit 4, and Unit 5. Select "AutoNumber" for the field type for the ID Number field. Select "Short Text" for the field type for all other fields. Set the ID Number field as the primary key.

3. Enter the names from Application 4-2 in the Customer table. In the Filing Segment field, enter the complete name as written. In the other fields, enter the data in all capital letters and follow the alphabetic indexing rules 5-8 presented in this chapter. (Do not enter information shown in parentheses after a company name in the Units fields.)

4. Sort the records in the Customer table in ascending order by the Key Unit field. Does the order of the records in the sorted table match the order of the records you sorted manually in Application 4-2? If not, how does the order differ?