Question 1

The view that allows you to enter,edit,and delete records directly is the Datasheet view.

Accepted Answer

A) True 
 B)False  True

Question 2

A field may be sorted in either ascending order or ________ order.

Accepted Answer

A)  reverse 
B)  descending 
C)  inclining 
D)  sloping 
A)  reverse 
B)  descending 
C)  inclining 
D)  sloping B

Question 3

Rearranging records in a specific order is called ________.

Accepted Answer

A)  sorting 
B)  categorizing 
C)  classifying 
D)  moving 
A)  sorting 
B)  categorizing 
C)  classifying 
D)  moving A

Question 4

In a datasheet,a special row that uses the aggregate function for one or more fields is called the total row.

Accepted Answer

A) True 
 B)False

Question 5

The ________ operator will return results that include and fall within the criteria you enter.

Accepted Answer

A)  LIKE 
B)  IN 
C)  BETWEEN 
D)  AND 
A)  LIKE 
B)  IN 
C)  BETWEEN 
D)  AND

Question 6

If you were trying to find all customers who lived in California,the best way to do this would be to type "CA" in the State field criteria box.

Accepted Answer

A) True 
 B)False

Question 7

The Find Duplicates Query Wizard finds duplicate records in related tables.

Accepted Answer

A) True 
 B)False

Question 8

The ________ gives you more control and options to manage the details of a query design than does the Simple Query Wizard.

Accepted Answer

The answer of The ________ gives you more control and...

Question 9

The Simple Query Wizard allows you to chose the tables and fields to include in the query,as well as select the criteria for the field values,create calculated fields,and select sorting options.

Accepted Answer

A) True 
 B)False

Question 10

When you sort text in A to Z order,you are using a(n)________ sorting option.

Accepted Answer

A)  normal 
B)  forward 
C)  descending 
D)  ascending 
A)  normal 
B)  forward 
C)  descending 
D)  ascending

Question 11

In Query Design view,you can select up to ________ fields to sort by.

Accepted Answer

A)  50 
B)  10 
C)  25 
D)  5 
A)  50 
B)  10 
C)  25 
D)  5

Question 12

The view that allows you to view all records in a table at one time is the design view.

Accepted Answer

A) True 
 B)False

Question 13

If columns are not wide enough to display all the contents,you can double-click on the right border of the column selector bar to increase the column width.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Accepted Answer

A)  duplicate 
B)  stray 
C)  orphan 
D)  widow 
A)  duplicate 
B)  stray 
C)  orphan 
D)  widow

Question 15

A(n)________ operator allows you to combine two or more criteria.

Accepted Answer

A)  criteria 
B)  logical 
C)  example 
D)  comparison 
A)  criteria 
B)  logical 
C)  example 
D)  comparison

Question 16

When inconsistent data,such as multiple spellings for the same name,are entered into a database,query results are not valid.

Accepted Answer

A) True 
 B)False

Question 17

Changing the font type,font size,column width and background colors can make your datasheet appear more ________.

Accepted Answer

The answer of Changing the font type,font size,column width and...

Question 18

The Find command quickly locates specific records using all or part of a field value in the Datasheet view.

Accepted Answer

A) True 
 B)False

Question 19

After you locate records with the Find command,you can replace them with the Change command.

Accepted Answer

A) True 
 B)False

Question 20

To view all the records in a table at one time,open the ________ view.

Accepted Answer

The answer of To view all the records in a...

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

The view that allows you to enter,edit,and delete records directly is the Datasheet view.

A field may be sorted in either ascending order or ________ order.

Rearranging records in a specific order is called ________.

In a datasheet,a special row that uses the aggregate function for one or more fields is called the total row.

The ________ operator will return results that include and fall within the criteria you enter.

If you were trying to find all customers who lived in California,the best way to do this would be to type "<>CA" in the State field criteria box.

The Find Duplicates Query Wizard finds duplicate records in related tables.

The ________ gives you more control and options to manage the details of a query design than does the Simple Query Wizard.

The Simple Query Wizard allows you to chose the tables and fields to include in the query,as well as select the criteria for the field values,create calculated fields,and select sorting options.

When you sort text in A to Z order,you are using a(n)________ sorting option.

In Query Design view,you can select up to ________ fields to sort by.

The view that allows you to view all records in a table at one time is the design view.

If columns are not wide enough to display all the contents,you can double-click on the right border of the column selector bar to increase the column width.

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

A(n)________ operator allows you to combine two or more criteria.

When inconsistent data,such as multiple spellings for the same name,are entered into a database,query results are not valid.

Changing the font type,font size,column width and background colors can make your datasheet appear more ________.

The Find command quickly locates specific records using all or part of a field value in the Datasheet view.

After you locate records with the Find command,you can replace them with the Change command.

To view all the records in a table at one time,open the ________ view.

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