Exam 17: Creating a Database

You need to save the database after each set of changes.

As an alternative to typing data into a database table, you can export data from files created with other software into Access._________________________

To hide a field, right-click the column title and select ____ from the shortcut menu.

When you create your own table in Design View you must specify a data type for each field.Please describe each of these data types: Text, Memo, AutoNumber, Yes/No.

When using the Simple Query Wizard, you will be asked "Would you like a detail or summary query?" Selecting the ____ option only displays how many records match your criteria.

Each ____ contains the data for one field.

A(n) ____________________ file, sometimes referred to as a CSV file (comma-separated values), is simply data separated by commas.

-In the figure above, you can click ____to edit the data it contains.

Use the ____ keys to delete text to the left or to the right of the insertion point, respectively.

Use the ____ data type for dates and times.

When you start Access, ____ appears.

The Yes/No data type can be useful for fields designed to hold simple Yes/No or True/False data._________________________

You can access the controls to add, delete, move, and sort data, by ____ the column or row you want to work with.

With Access, first you save an empty database, then you create the elements that make up the database.

When using the Simple Query Wizard, after you enter a title and click the Finish button, the query results appear in ____.