Question 1

Filters are used to select a subset of records in a datasheet.

Accepted Answer

A) True 
 B)False

Question 2

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Accepted Answer

A) True 
 B)False

Question 3

Explain the difference between AND and OR criteria.

Accepted Answer

AND: All criteria must be true in order

Question 4

The purpose of a report is to provide an easy-to-use data entry interface.

Accepted Answer

A) True 
 B)False

Question 5

A(n) ____________________ answers a question about the information in the database.

Accepted Answer

The answer of A(n) ____________________ answers a question about the...

Question 6

In the accompanying figure, "StateName" and "Price" are ____ names.

Accepted Answer

A)  table 
B)  report 
C)  field 
D)  query 
A)  table 
B)  report 
C)  field 
D)  query

Question 7

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Accepted Answer

A) True 
 B)False

Question 8

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 9

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False

Question 10

By default, the printout of a datasheet contains the object name and current date in the footer . ____________________

Accepted Answer

A) True 
 B)False

Question 11

Which shortcut key moves focus to the previous field of the current record?

Accepted Answer

A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5] 
A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5]

Question 12

Which two sections can be added to a report if you group records?

Accepted Answer

A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail 
A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail

Question 13

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Accepted Answer

A)  0 
B)  Is Not Null 
C)  *=* 
D)  * * 
A)  0 
B)  Is Not Null 
C)  *=* 
D)  * *

Question 14

Discuss adding or deleting a table in a query.

Accepted Answer

You might want to add a table's field li

Question 15

Microsoft Access can best be described as ____ software.

Accepted Answer

A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems 
A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems

Question 16

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Accepted Answer

A)  Report View 
B)  Print Preview 
C)  Layout View 
D)  Design View 
A)  Report View 
B)  Print Preview 
C)  Layout View 
D)  Design View

Question 17

A(n) ____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 18

Match between columns
                        Premises: Creates a temporary subset of records
Criterion that finds all records where no entry has been made in the field
Allows you to apply some basic formatting modifications such as changing the font size, font face, colors, and gridlines
Putting records in ascending or descending order based on a field's values
Creates a datasheet of selected fields and records from one or more tables
Limiting conditions used to narrow the number of records on a datasheet
Used to search for a pattern
The lower pane in Query Design View

Accepted Answer

The Answer of query and wildcard and criteria and query is...

Question 19

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 20

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Accepted Answer

A)  filter 
B)  query 
C)  grid 
D)  sort 
A)  filter 
B)  query 
C)  grid 
D)  sort

Filters are used to select a subset of records in a datasheet.

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Explain the difference between AND and OR criteria.

The purpose of a report is to provide an easy-to-use data entry interface.

A(n) ____________________ answers a question about the information in the database.

In the accompanying figure, "StateName" and "Price" are ____ names.

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Field properties change depending on the data type of the field.

An Access database is limited to a size of 1 gigabyte.

By default, the printout of a datasheet contains the object name and current date in the footer . ____________________

Which shortcut key moves focus to the previous field of the current record?

Which two sections can be added to a report if you group records?

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Discuss adding or deleting a table in a query.

Microsoft Access can best be described as ____ software.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

A(n) ____________________ field automatically assigns a new number each time you add a record.

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Excel 2013 Getting Started With Excel 2013

Filters

Exam 7: Access 2013 Getting Started With Access 2013

Filters are used to select a subset of records in a datasheet.

It would make sense to set the Tab Stop property of a text box that will not be used for data entry to No.

Explain the difference between AND and OR criteria.

The purpose of a report is to provide an easy-to-use data entry interface.

A(n) ____________________ answers a question about the information in the database.

In the accompanying figure, "StateName" and "Price" are ____ names.

If you want to apply the same formatting enhancement to multiple controls, select them at the same time to make the same change to both.

Field properties change depending on the data type of the field.

An Access database is limited to a size of 1 gigabyte.

By default, the printout of a datasheet contains the object name and current date in the footer . ____________________

Which shortcut key moves focus to the previous field of the current record?

Which two sections can be added to a report if you group records?

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

Discuss adding or deleting a table in a query.

Microsoft Access can best be described as ____ software.

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

A(n) ____________________ field automatically assigns a new number each time you add a record.

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Excel 2013 Getting Started With Excel 2013

Filters