Question 1

With an action query, the records in the table are changed ____.

Accepted Answer

A)  after you run the query 
B)  as soon as you run the query 
C)  after the next replication 
D)  before the next replication 
A)  after you run the query 
B)  as soon as you run the query 
C)  after the next replication 
D)  before the next replication

Question 2

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.

Accepted Answer

A)  use the Sum built-in function 
B)  use the Average built-in function 
C)  create a new function called CalcAvg 
D)  use another programming language 
A)  use the Sum built-in function 
B)  use the Average built-in function 
C)  create a new function called CalcAvg 
D)  use another programming language

Question 3

Match between columns
                        Premises: Places the dollar sign and commas in the control.

Accepted Answer

The Answer of chart and summary report and currency format is...

Question 4

A ____ can be clicked to move within a form.

Accepted Answer

A)  calculated control button 
B)  command button 
C)  control button 
D)  command tab 
A)  calculated control button 
B)  command button 
C)  control button 
D)  command tab

Question 5

Match between columns
                        Premises: Stores Yes/No, True/False, or On/Off values.

Accepted Answer

The Answer of Currency and Date/Time and Memo and Text is...

Question 6

Parameter means to ____.

Accepted Answer

A)  remove 
B)  embed 
C)  vary 
D)  add 
A)  remove 
B)  embed 
C)  vary 
D)  add

Question 7

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Section is printed at the top of every page of the report.

Accepted Answer

The Answer of Group Header and Detail and Report Footer is...

Question 9

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

Accepted Answer

A)  prompt you to save your changes 
B)  automatically save your changes 
C)  give you an error message 
D)  close the table 
A)  prompt you to save your changes 
B)  automatically save your changes 
C)  give you an error message 
D)  close the table

Question 10

Match between columns
                        Premises: Allow a different criterion each time the query runs.

Accepted Answer

The Answer of parameter queries and action queries and update is...

Question 11

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. To satisfy the auditor's request, Ted should use the ____ tool.

Accepted Answer

A)  Recorder 
B)  Database log 
C)  Database Recorder 
D)  Database Documenter 
A)  Recorder 
B)  Database log 
C)  Database Recorder 
D)  Database Documenter

Question 12

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

Accepted Answer

A)  New 
B)  Create 
C)  Table 
D)  Datasheet 
A)  New 
B)  Create 
C)  Table 
D)  Datasheet

Question 13

Access is a DBBS program.

Accepted Answer

A) True 
 B)False

Question 14

To avoid losing database information, you can open a database in the Open Exclusive mode.

Accepted Answer

A) True 
 B)False

Question 15

The unbound part of a Text Box control remains unbound until a(n) field with actual data is assigned to the control.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Section is printed once at the bottom of the last page of the report, and usually includes summary information for the entire report.

Accepted Answer

The Answer of Group Header and Page Header and Detail is...

Question 17

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

Accepted Answer

The answer of A form's style, also called a(n) ____________________,...

Question 18

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

Accepted Answer

A)  Paste End 
B)  Paste Special 
C)  Paste Append 
D)  Paste As 
A)  Paste End 
B)  Paste Special 
C)  Paste Append 
D)  Paste As

Question 19

A(n) ____________________ query moves data from one table to another table.

Accepted Answer

The answer of A(n) ____________________ query moves data from one...

Question 20

Explain why you should use the same style throughout the database.

Accepted Answer

Once you decide on the navigation form l

With an action query, the records in the table are changed ____.

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.

A ____ can be clicked to move within a form.

Parameter means to ____.

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. To satisfy the auditor's request, Ted should use the ____ tool.

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

Access is a DBBS program.

To avoid losing database information, you can open a database in the Open Exclusive mode.

The unbound part of a Text Box control remains unbound until a(n) field with actual data is assigned to the control.

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

A(n) ____________________ query moves data from one table to another table.

Explain why you should use the same style throughout the database.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

With an action query, the records in the table are changed ____.

AC Adv Case 13-1 Eric has been asked to write a VBA function to calculate the average salaries for his company's salespeople for the past five years. Eric asks for your help in getting started with VBA programming using the company's salary database. You suggest that Eric ____.

A ____ can be clicked to move within a form.

Parameter means to ____.

Most database experts agree that users should make all database updates by using a form, instead of by using table datasheets.

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. To satisfy the auditor's request, Ted should use the ____ tool.

After specifying the file name and the location in which to store the database, click the ____ button to create the new database and open it in Access.

Access is a DBBS program.

To avoid losing database information, you can open a database in the Open Exclusive mode.

The unbound part of a Text Box control remains unbound until a(n) field with actual data is assigned to the control.

A form's style, also called a(n) ____________________, formats the form and its controls using a predefined color, font, and design scheme.

If you copy an entire record and want to paste it into a table as a new record, use the ____ command.

A(n) ____________________ query moves data from one table to another table.

Explain why you should use the same style throughout the database.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters