Last But Not Least...

Each of the simple steps in the previous pages confirmed that the Microsoft Excel spreadsheet was successfully imported into a new Table in Microsoft Access.

 

There is one more task to complete. This is the Movies Table. The Movies Table should have a MovieID that matches.

 

6. Try it: Change the Table View

tblMovies is open in Datasheet View.
Go to
Home ->Views->View.

Select: Design View.

 

Keep going...

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.1.1. Create tables in Design View

Home->Views->View->Design View