Question 1

When you _____ a database,you reduce the size of the database by up to 75 percent.

Accepted Answer

A)  back up 
B)  trust and verify 
C)  analyze 
D)  compact and repair 
A)  back up 
B)  trust and verify 
C)  analyze 
D)  compact and repair

Question 2

In a datasheet,what do you click to select a record for deletion?

Accepted Answer

A)  column heading 
B)  field in the record 
C)  record deletion button 
D)  record selector button 
A)  column heading 
B)  field in the record 
C)  record deletion button 
D)  record selector button

Question 3

_____ is the default name for a new table in an Access database.

Accepted Answer

A)  Table1 
B)  NewTable 
C)  Table 
D)  TableA 
A)  Table1 
B)  NewTable 
C)  Table 
D)  TableA

Question 4

Microsoft Access 2016 can best be described as ____ software.

Accepted Answer

A)  spreadsheet 
B)  relationship 
C)  utility 
D)  database 
A)  spreadsheet 
B)  relationship 
C)  utility 
D)  database

Question 5

The first step in the Form Wizard is to _____.

Accepted Answer

A)  select a layout for the form 
B)  select a sort order for the records 
C)  select the fields to include in the form 
D)  provide a name for the form 
A)  select a layout for the form 
B)  select a sort order for the records 
C)  select the fields to include in the form 
D)  provide a name for the form

When you _____ a database,you reduce the size of the database by up to 75 percent.

In a datasheet,what do you click to select a record for deletion?

_____ is the default name for a new table in an Access database.

Microsoft Access 2016 can best be described as ____ software.

The first step in the Form Wizard is to _____.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 1: Getting Started With Excel

When you _____ a database,you reduce the size of the database by up to 75 percent.

In a datasheet,what do you click to select a record for deletion?

_____ is the default name for a new table in an Access database.

Microsoft Access 2016 can best be described as ____ software.

The first step in the Form Wizard is to _____.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters