Exam 22: Getting Started With Access Essentials

The Blank Database button is located in the ____.

Case 22-1 Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view. What setting will allow Dana to change the number of characters allowed in a field?

____ is the shortcut for creating a new blank database.

You can use the Save As command to save the entire database under a new name.

The ____ determines what type of data the field can store, such as text or numbers.

Objects are organized into categories in the Navigation Pane.

The intersection of a row and a column is called a(n) ____________________, just as in an Excel worksheet.

You cannot use the Save As command to name and save objects in the database.

The Access screen is similar to other Office 2007 applications.

A(n) ____________________ is a collection of related information.

Case 22-1 Dana has just been hired to create and maintain a database for a local sports organization. The organization has several different sports with many teams and divisions. She is creating the database in Design view. If Dana doesn't save the table in Design view and switches to Datasheet view, what will happen?

The ____ is useful in sorting records, and it prevents duplicate entries.

When you work in ____ view, the changes are saved as they are made.

____ is the illegal copying or use of programs.

If you make a mistake adding or editing data in a record, you can choose the ____________________ command to reverse your last action.

The ____ key moves the insertion point to the first field in the current record.

Access is a database program.

Unlike Word and Excel, Access does not have a standard document view.

Fields appear as columns, and each column has a ____.

What is the difference between a spreadsheet and a database? Give an example of when you would use each and explain why. Explain a relational database management system.