Exam 1: Creating a Database

Identify the letter of the choice that best matches the phrase or definition. -A status box that displays the number of the current record and the total number of records in a table.

(Multiple Choice)

4.8/5

(35)

Question 21

Identify the letter of the choice that best matches the phrase or definition. -A field,or collection of fields,whose values are used to uniquely identify each record in a table.

(Multiple Choice)

4.8/5

(35)

Question 22

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.

(Multiple Choice)

4.9/5

(38)

Question 23

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

(Multiple Choice)

4.7/5

(44)

Question 24

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

(Multiple Choice)

4.8/5

(30)

Question 25

Each column in an Access table datasheet represents a ____.

(Multiple Choice)

4.9/5

(32)

Question 26

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

(Short Answer)

4.7/5

(42)

Question 27

All of the data in a relational database are contained in ____________________.

(Short Answer)

4.8/5

(30)

Question 28

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

(True/False)

4.8/5

(22)

Question 29

Which Access feature provides information about Access commands and features and instructions about how to use them?

(Multiple Choice)

4.8/5

(41)

Question 30

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

(True/False)

4.9/5

(32)

Question 31

Another term used for the column selector feature is ____.

(Multiple Choice)

4.8/5

(36)

Question 32

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

(True/False)

4.7/5

(36)

Question 33

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

(Short Answer)

4.9/5

(24)

Question 34

Identify the letter of the choice that best matches the phrase or definition. -A question that is asked about the data stored in a database.

(Multiple Choice)

4.8/5

(45)

Question 35

What is the purpose of the primary key?

(Multiple Choice)

4.8/5

(30)

Question 36

Identify the letter of the choice that best matches the phrase or definition. -The Access 2016 view that shows the number of pages that will be printed.

(Multiple Choice)

4.8/5

(28)

Question 37

What are the five primary functions of a Database Management System (DBMS)?

(Short Answer)

4.9/5

(37)

Question 38

Identify the letter of the choice that best matches the phrase or definition. -An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

(Multiple Choice)

5.0/5

(35)

Question 39

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

(Multiple Choice)

4.8/5

(28)

Question 40

Showing 21 - 40 of 75

Identify the letter of the choice that best matches the phrase or definition. -A status box that displays the number of the current record and the total number of records in a table.

Identify the letter of the choice that best matches the phrase or definition. -A field,or collection of fields,whose values are used to uniquely identify each record in a table.

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.

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

Each column in an Access table datasheet represents a ____.

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

All of the data in a relational database are contained in ____________________.

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

Which Access feature provides information about Access commands and features and instructions about how to use them?

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

Another term used for the column selector feature is ____.

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

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Identify the letter of the choice that best matches the phrase or definition. -A question that is asked about the data stored in a database.

What is the purpose of the primary key?

Identify the letter of the choice that best matches the phrase or definition. -The Access 2016 view that shows the number of pages that will be printed.

What are the five primary functions of a Database Management System (DBMS)?

Identify the letter of the choice that best matches the phrase or definition. -An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters