Create a New Table

Every business needs a customer table. Close tblMovies and go to Create Table Design to open a new table in Design View.

 

1. Create a Customer Table

Go to Create

Select Table Design

 

2. Enter the Field

Type the Field Name: LastName

Select Data Type: Text

 

3. Modify the Field Properties

The maximum Field Size is 255 characters. In previous versions of Access the default size was only 50. characters. Native and hyphenated names require more than 50.

 

Should field names include spaces? It is easier to omit the spaces between the words in a field name. When Microsoft Access finds a field name with spaces, the database will alter name with an underscore like this: Last_Name