Exam 1: Getting Started With Access 2.0

Which is NOT a feature of Access reports?

What are the advantages of database software such as Access over spreadsheet software such as Excel?

You can use the Calendar Box to enter dates in a Date/Time field.

You can move datasheet columns by dragging the field name left or right.

Field properties change depending on the data type of the field.

A(n) ____________________ key field contains unique data for each record.

Lauren wants to create an Access database of the musical instruments she owns.She has written a paragraph describing the use for each inventory item.Which data type should she use to define the field that will store this information?

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Which data type links files created in other programs such as pictures, sound clips, or documents?

Which two properties are required for every field?

Press this keystroke combination to move focus to the last field of the last record.

A(n) ____________________ object provides an easy-to-use data entry screen.

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

The navigation buttons are found at the top of the datasheet.

Which data type is used to sequentially order each record added to a table?

The Database window displays the Tables, Queries, Forms, and Reports.Describe what these four objects represent.

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Pressing [Ctrl][;] will insert the current date in a Date field.