Question 1

Access is preferred over Excel in managing mostly numeric data.

Accepted Answer

A) True 
 B)False

Question 2

The navigation buttons in Access allow you to step through a table record by record, or to quickly go to the first or last record in the table.

Accepted Answer

A) True 
 B)False

Question 3

________ sorts a list of numeric data from highest to lowest.

Accepted Answer

The answer of ________ sorts a list of numeric data...

Question 4

Match the following terms to their meanings:
I. criterion
II. filter
III. normalization
IV. comparison operator
V. foreign key
A. process of grouping data into correct tables
B. display of a subset of records
C. evaluates the relationship between two quantities
D. number, text phrase, or expression used to select records from a table
E. a field in one table that is the primary key in another table

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 5

Match between columns
                        Premises: contextual tab
Mini toolbar
title bar
gallery
status bar

Accepted Answer

The Answer of easy access to formatting commands and contains is...

Question 6

What is one limit to two users working on the same database file at the same time?

Accepted Answer

Student answers may vary. One limit is t

Question 7

Access' ________ feature creates a duplicate copy of a database.

Accepted Answer

A)  Back Up Database 
B)  RDBMA 
C)  Compact and Repair 
D)  Relationship 
A)  Back Up Database 
B)  RDBMA 
C)  Compact and Repair 
D)  Relationship

Question 8

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Accepted Answer

A)  Database 
B)  Query 
C)  Table 
D)  Report 
A)  Database 
B)  Query 
C)  Table 
D)  Report

Question 9

Access allows you to save a database as a PDF or ________ file, which preserves the object's formatting and looks the same on most computers.

Accepted Answer

The answer of Access allows you to save a database...

Question 10

Match the following keys to their functions:
I. F11
II. F2
II. Tab
IV. Home
V. Esc
A. moves insertion point right one field in the same row of a database
B. moves insertion point to the first field in the current row of a database
C. cancels any change made in a current field while in Edit mode
D. toggles the Navigation Pane on and off
E. switch to Edit mode

Accepted Answer

The answer of Match the following keys to their functions:
I....

Question 11

A relationship is a connection between:

Accepted Answer

A)  two tables using a field that is common to both. 
B)  two or more database files with a common primary field. 
C)  two records within the same database. 
D)  two or more tables using a common record. 
A)  two tables using a field that is common to both. 
B)  two or more database files with a common primary field. 
C)  two records within the same database. 
D)  two or more tables using a common record.

Question 12

Which one of the following objects allows users to add data to the database?

Accepted Answer

A)  Table 
B)  Record 
C)  Query 
D)  Form 
A)  Table 
B)  Record 
C)  Query 
D)  Form

Question 13

Custom Web app is available in the Backstage view of Access.

Accepted Answer

A) True 
 B)False

Question 14

________ view is a grid containing fields and records.

Accepted Answer

The answer of ________ view is a grid containing fields...

Question 15

Rather than displaying records based on a question as in a query, a(n) ________ hides records that do not match a set criteria.

Accepted Answer

The answer of Rather than displaying records based on a...

Question 16

Which of the following is NOT a method for creating a new database?

Accepted Answer

A)  A blank desktop database 
B)  A database from a style 
C)  A custom Web app 
D)  A database from a template 
A)  A blank desktop database 
B)  A database from a style 
C)  A custom Web app 
D)  A database from a template

Question 17

Microsoft ________ is the database management system included in Office 20013 Professional.

Accepted Answer

The answer of Microsoft ________ is the database management system...

Question 18

Click the File tab to begin the process of compacting and repairing a database.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Ctrl+C
Ctrl+V
Ctrl+Z
Ctrl+X
Ctrl+A

Accepted Answer

The Answer of Copy and Paste and Select all and is...

Question 20

Which of the following is FALSE about the Undo feature in Access?

Accepted Answer

A)  You can click Undo to reverse the most recent change to a single record. 
B)  You can use Undo to reverse multiple edits in Access. 
C)  In Access, the Undo feature works the same as it does in other Office programs. 
D)  You can click Undo to redo a change that you made previously. 
A)  You can click Undo to reverse the most recent change to a single record. 
B)  You can use Undo to reverse multiple edits in Access. 
C)  In Access, the Undo feature works the same as it does in other Office programs. 
D)  You can click Undo to redo a change that you made previously.

Access is preferred over Excel in managing mostly numeric data.

The navigation buttons in Access allow you to step through a table record by record, or to quickly go to the first or last record in the table.

________ sorts a list of numeric data from highest to lowest.

What is one limit to two users working on the same database file at the same time?

Access' ________ feature creates a duplicate copy of a database.

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Access allows you to save a database as a PDF or ________ file, which preserves the object's formatting and looks the same on most computers.

A relationship is a connection between:

Which one of the following objects allows users to add data to the database?

Custom Web app is available in the Backstage view of Access.

________ view is a grid containing fields and records.

Rather than displaying records based on a question as in a query, a(n) ________ hides records that do not match a set criteria.

Which of the following is NOT a method for creating a new database?

Microsoft ________ is the database management system included in Office 20013 Professional.

Click the File tab to begin the process of compacting and repairing a database.

Which of the following is FALSE about the Undo feature in Access?

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

Exam 1: Introduction to Access: Finding Your Way Through an Access Database

Access is preferred over Excel in managing mostly numeric data.

The navigation buttons in Access allow you to step through a table record by record, or to quickly go to the first or last record in the table.

________ sorts a list of numeric data from highest to lowest.

What is one limit to two users working on the same database file at the same time?

Access' ________ feature creates a duplicate copy of a database.

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Access allows you to save a database as a PDF or ________ file, which preserves the object's formatting and looks the same on most computers.

A relationship is a connection between:

Which one of the following objects allows users to add data to the database?

Custom Web app is available in the Backstage view of Access.

________ view is a grid containing fields and records.

Rather than displaying records based on a question as in a query, a(n) ________ hides records that do not match a set criteria.

Which of the following is NOT a method for creating a new database?

Microsoft ________ is the database management system included in Office 20013 Professional.

Click the File tab to begin the process of compacting and repairing a database.

Which of the following is FALSE about the Undo feature in Access?

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters