FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Access-Module 1: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

Access report printing options may be changed using the Navigation dialog box. _________________________

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

Correct Answer

verified

Show Answer

Question 3

Matching

Review LaterAdd Note

Identify the letter of the choice that best matches the phrase or definition.

Field values that may be entered into a field are determined by the data type of the field.  _________________________

Identify the letter of the choice that best matches the phrase or definition.

Which data type allows field values to contain letters, digits, and other characters?

Compacting a database rearranges the data and objects in a database to decrease its file size.  _________________________

What function does compacting an Access database perform other than reducing the file size?

Identify the letter of the choice that best matches the phrase or definition.

It is possible to view all Access objects in the Navigation Pane .  _________________________

Which of the following is the file extension used for Access 2016 database files?

Explain the difference between a primary key and a foreign key.

Which Access 2016 view contains commands used to manage Access files and options?

Data organized as a collection of tables creates this type of data system.

An important reference tool available in Access 2016, which may be used to assist a user with problems that might occur, is the ____________________ system.

The default ____________________ provided by Access is the ID field.

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.  _________________________

To save a table in Access with a name that relates to the database (a name other than the Access default name) , it is necessary to complete which process?

Each record in a table is uniquely identified by a foreign key.  _________________________

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.