Question 1

Which control allows you to type an entry or choose an entry from a list?

Accepted Answer

A)  combo box 
B)  list box 
C)  label 
D)  text box 
A)  combo box 
B)  list box 
C)  label 
D)  text box

Question 2

Which of the following is a way to move selected controls with precision in Form Design view?

Accepted Answer

A)  Press an arrow key. 
B)  Drag the controls. 
C)  Double-click the horizontal or vertical ruler. 
D)  Use the Go To dialog box. 
A)  Press an arrow key. 
B)  Drag the controls. 
C)  Double-click the horizontal or vertical ruler. 
D)  Use the Go To dialog box.

Question 3

A common way to run a macro is to assign it to a command button.

Accepted Answer

A) True 
 B)False

Question 4

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

Accepted Answer

A) True 
 B)False

Question 5

If a database contains VBA code, you can save the database as an ACCDE file to prevent people from viewing or changing the VBA code.

Accepted Answer

A) True 
 B)False

Question 6

To add a report to a Navigation form, change the report's Display property to Navigation.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

Accepted Answer

A)  %5/7/2021% 
B)  >5/7/2021 
C)  #5/7/2021# 
D)  "5/7/2021" 
A)  %5/7/2021% 
B)  >5/7/2021 
C)  #5/7/2021# 
D)  "5/7/2021"

Question 8

If you export report data as an RTF or XML file, you can open the exported file in a browser.

Accepted Answer

A) True 
 B)False

Question 9

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

Accepted Answer

A)  navigation form 
B)  tab control 
C)  subform 
D)  split form 
A)  navigation form 
B)  tab control 
C)  subform 
D)  split form

Question 10

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 11

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Accepted Answer

A)  the Field List 
B)  Datasheet View 
C)  the Navigation Pane 
D)  Design View 
A)  the Field List 
B)  Datasheet View 
C)  the Navigation Pane 
D)  Design View

Question 12

Which process is most like copying and pasting?

Accepted Answer

A)  importing 
B)  relating 
C)  querying 
D)  linking 
A)  importing 
B)  relating 
C)  querying 
D)  linking

Question 13

Which of the following statements creates a function named Bonus with an argument named Salary?

Accepted Answer

A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary) 
A)  Bonus(Salary) = Function 
B)  Function Bonus(Salary) 
C)  Function (Bonus, Salary) 
D)  '=Function(Bonus, Salary)

Question 14

How do you rename a table?

Accepted Answer

A)  Right-click the object tab in the Access window, and then click Rename. 
B)  Right-click the table in the Navigation Pane, and then click Rename. 
C)  Click the table in the Navigation Pane, and then click the Rename button. 
D)  Open the table in Table Datasheet view, and then click the Rename button. 
A)  Right-click the object tab in the Access window, and then click Rename. 
B)  Right-click the table in the Navigation Pane, and then click Rename. 
C)  Click the table in the Navigation Pane, and then click the Rename button. 
D)  Open the table in Table Datasheet view, and then click the Rename button.

Question 15

Which of the following could you use to export records to a new table?

Accepted Answer

A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query 
A)  Parameter query 
B)  Make-Table query 
C)  Update query 
D)  Delete query

Question 16

To relate two fields in a one-to-many relationship, you connect them using a _____.

Accepted Answer

A)  subdatasheet 
B)  common field 
C)  field key 
D)  data type 
A)  subdatasheet 
B)  common field 
C)  field key 
D)  data type

Question 17

To temporarily remove the display of a selected field in Table Datasheet view, right-click the field and then click _____.

Accepted Answer

A)  Unhide Fields 
B)  Freeze Fields 
C)  Delete Fields 
D)  Hide Fields 
A)  Unhide Fields 
B)  Freeze Fields 
C)  Delete Fields 
D)  Hide Fields

Question 18

How do you specify an outer join between two tables?

Accepted Answer

A)  In the Relationships window, click the Modify Join button. 
B)  In Query Design View, double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid. 
A)  In the Relationships window, click the Modify Join button. 
B)  In Query Design View, double-click the join line. 
C)  Add the "outer" criterion to the query design grid. 
D)  Change the order of the fields in the query design grid.

Question 19

What is the most efficient way to navigate to the last record in a table containing 100 records?

Accepted Answer

A)  Press the END key. 
B)  Press TAB as many times as necessary. 
C)  Use the Next record button on the navigation bar. 
D)  Use the Last record button on the navigation bar. 
A)  Press the END key. 
B)  Press TAB as many times as necessary. 
C)  Use the Next record button on the navigation bar. 
D)  Use the Last record button on the navigation bar.

Question 20

Eric wants to remove records from the Offices table for offices in Texas. What type of query should he create?

Accepted Answer

A)  Delete 
B)  Make-Table 
C)  Crosstab 
D)  Update 
A)  Delete 
B)  Make-Table 
C)  Crosstab 
D)  Update

Which control allows you to type an entry or choose an entry from a list?

Which of the following is a way to move selected controls with precision in Form Design view?

A common way to run a macro is to assign it to a command button.

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

If a database contains VBA code, you can save the database as an ACCDE file to prevent people from viewing or changing the VBA code.

To add a report to a Navigation form, change the report's Display property to Navigation.

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

If you export report data as an RTF or XML file, you can open the exported file in a browser.

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which process is most like copying and pasting?

Which of the following statements creates a function named Bonus with an argument named Salary?

How do you rename a table?

Which of the following could you use to export records to a new table?

To relate two fields in a one-to-many relationship, you connect them using a _____.

To temporarily remove the display of a selected field in Table Datasheet view, right-click the field and then click _____.

How do you specify an outer join between two tables?

What is the most efficient way to navigate to the last record in a table containing 100 records?

Eric wants to remove records from the Offices table for offices in Texas. What type of query should he create?

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 1: Access 2019

Which control allows you to type an entry or choose an entry from a list?

Which of the following is a way to move selected controls with precision in Form Design view?

A common way to run a macro is to assign it to a command button.

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

If a database contains VBA code, you can save the database as an ACCDE file to prevent people from viewing or changing the VBA code.

To add a report to a Navigation form, change the report's Display property to Navigation.

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

If you export report data as an RTF or XML file, you can open the exported file in a browser.

The upper pane of a _____ displays the fields of one record, and the lower pane shows a datasheet view of the first few records.

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which process is most like copying and pasting?

Which of the following statements creates a function named Bonus with an argument named Salary?

How do you rename a table?

Which of the following could you use to export records to a new table?

To relate two fields in a one-to-many relationship, you connect them using a _____.

To temporarily remove the display of a selected field in Table Datasheet view, right-click the field and then click _____.

How do you specify an outer join between two tables?

What is the most efficient way to navigate to the last record in a table containing 100 records?

Eric wants to remove records from the Offices table for offices in Texas. What type of query should he create?

Excel 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters