Review the Data

A database is only as good as the data. What kind of data is in this database?

 

Try This: Review the Data

Go the All Access Objects.

Double-click a Table: tblMovies

 

What Do You See? There are 401 movies in tblMovies.

 

Try This, Too: Sort the Data

Select the Rating and Genre Columns.

Go to Table Tools->Sort & Filter.

Select: Ascending.

 

What Do You See, Now? The movie records aren't complete. Some of the movies do not have a Rating, some do not have a Genre. Many are missing both. This will be part of our discussions, later.

 

OK! Save the Table

Go to File->Save.

Close the Table, too.

Table Tools->Sort & Filter->Ascending

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.3. Sort and filter records: Sort