Question 1

To view all the table records at one time,use the ________ view.

Accepted Answer

A)  spreadsheet 
B)  datasheet 
C)  design 
D)  worksheet 
A)  spreadsheet 
B)  datasheet 
C)  design 
D)  worksheet

Question 2

LIKE,IN,and BETWEEN are called ________.

Accepted Answer

A)  comparison operators 
B)  different operators 
C)  special operators 
D)  logical operators 
A)  comparison operators 
B)  different operators 
C)  special operators 
D)  logical operators

Question 3

A multiple-table ________ retrieved information from more than one table or query.

Accepted Answer

The answer of A multiple-table ________ retrieved information from more...

Question 4

A(n)________ works by prompting you to answer a series of questions about the tables and fields to display,then creating the query based on your response.

Accepted Answer

The answer of A(n)________ works by prompting you to answer...

Question 5

To calculate multiple functions on the same field,you must add the field to the ________ multiple times.

Accepted Answer

A)  form 
B)  query 
C)  grid 
D)  total row 
A)  form 
B)  query 
C)  grid 
D)  total row

Question 6

When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.

Accepted Answer

A) True 
 B)False

Question 7

Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.

Accepted Answer

A)  form design wizard 
B)  total row grid 
C)  query design wizard 
D)  query design grid 
A)  form design wizard 
B)  total row grid 
C)  query design wizard 
D)  query design grid

Question 8

In Design view,tables can be added to a query by dragging them from the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 9

To show aggregate functions for one or more fields at the end of a datasheet,you would use the ________.

Accepted Answer

A)  aggregate row 
B)  sum row 
C)  total column 
D)  total row 
A)  aggregate row 
B)  sum row 
C)  total column 
D)  total row

Question 10

________ characters are used as placeholders for unknown parts of values or to match certain patterns in a value.

Accepted Answer

The answer of ________ characters are used as placeholders for...

Question 11

For a field to be used in a query,it must first be added to the ________.

Accepted Answer

The answer of For a field to be used in...

To view all the table records at one time,use the ________ view.

LIKE,IN,and BETWEEN are called ________.

A multiple-table ________ retrieved information from more than one table or query.

A(n)________ works by prompting you to answer a series of questions about the tables and fields to display,then creating the query based on your response.

To calculate multiple functions on the same field,you must add the field to the ________ multiple times.

When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.

Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.

In Design view,tables can be added to a query by dragging them from the Navigation Pane.

To show aggregate functions for one or more fields at the end of a datasheet,you would use the ________.

________ characters are used as placeholders for unknown parts of values or to match certain patterns in a value.

For a field to be used in a query,it must first be added to the ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters

Exam 7: Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

To view all the table records at one time,use the ________ view.

LIKE,IN,and BETWEEN are called ________.

A multiple-table ________ retrieved information from more than one table or query.

A(n)________ works by prompting you to answer a series of questions about the tables and fields to display,then creating the query based on your response.

To calculate multiple functions on the same field,you must add the field to the ________ multiple times.

When two tables containing 100 records each are used in a query and the query returns 10,000 records,you know this is a result of the multiplier effect.

Though field names can be changed or assigned in an aggregate query,the field name in the ________ must stay the same so that Access knows what field to perform calculations on.

In Design view,tables can be added to a query by dragging them from the Navigation Pane.

To show aggregate functions for one or more fields at the end of a datasheet,you would use the ________.

________ characters are used as placeholders for unknown parts of values or to match certain patterns in a value.

For a field to be used in a query,it must first be added to the ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters