FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Word Module Access Module Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

When using a mouse while in an Access 2016 work session, access a shortcut menu for an object by performing this task.

A) scroll the vertical scroll bar
B) scroll the horizontal scroll bar
C) cllick on the Navigation Pane
D) right click

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 22

Matching

Review LaterAdd Note

Review Later

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

Premises

Responses

A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Print Preview

A status box that displays the number of the current record and the total number of records in a table.

File tab

The Access 2016 view that allows the user to manage files and options.

Backstage view

AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

field value

The specific content of a field.

primary key

The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

data type

An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

query

The Access Ribbon tab that offers the option for the user to compact and repair a database.

Create tab

The Access 2016 view that shows the number of pages that will be printed.

Current Record Box

A question that is asked about the data stored in a database.

Simple Query Wizard

Premises

A field, or collection of fields, whose values are used to uniquely identify each record in a table.

A status box that displays the number of the current record and the total number of records in a table.

The Access 2016 view that allows the user to manage files and options.

AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

The specific content of a field.

The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

The Access Ribbon tab that offers the option for the user to compact and repair a database.

The Access 2016 view that shows the number of pages that will be printed.

A question that is asked about the data stored in a database.

Responses

Print Preview

File tab

Backstage view

field value

primary key

data type

query

Create tab

Current Record Box

Simple Query Wizard

Show Answer

Correct Answer

Premises

Responses

A field, or collection of fields, whose values are used to uniquely identify each record in a table.

A status box that displays the number of the current record and the total number of records in a table.

The Access 2016 view that allows the user to manage files and options.

AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

The specific content of a field.

The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

The Access Ribbon tab that offers the option for the user to compact and repair a database.

The Access 2016 view that shows the number of pages that will be printed.

A question that is asked about the data stored in a database.

Premises

A field, or collection of fields, whose values are used to uniquely identify each record in a table.

A status box that displays the number of the current record and the total number of records in a table.

The Access 2016 view that allows the user to manage files and options.

AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

The specific content of a field.

The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

The Access Ribbon tab that offers the option for the user to compact and repair a database.

The Access 2016 view that shows the number of pages that will be printed.

A question that is asked about the data stored in a database.

Responses

Question 23

Multiple Choice

Review LaterAdd Note

Which button is used to open and close the Navigation Pane?

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

What is the purpose of the primary key?

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. 

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. 

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ____________________.

Each row in an Access table datasheet displays which of the following?

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).  

A formatted printout (or screen display) of the contents of one or more tables or queries is a  form . 

A database or a relational database is a collection of related tables. 

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

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

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

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

A question asked about the data stored in a database is called a primary key. 

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?