Exam 1: Access 1: Getting Started With Access

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Characteristics, such as Field Name and Data Type, are ____________________  that define a field.​

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

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

In Access, data entry screens are called forms . _________________________

Access databases cannot be password protected.​

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

Which is NOT true about Access?

No two records can have the same value in the primary key field.

Microsoft Access 2016 can best be described as ____ software.

____________________ View is a spreadsheet-like view of the data in a table.

"Focus" refers to which data you would edit if you started typing.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren 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?

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Which of the following keys will help you delete unwanted data in Edit mode?

A primary key field uniquely identifies each record.

In a datasheet, which mode assumes that you are trying to change the value of a particular field?