Question 1

Access prevents you from using parameters and wildcards in the same query.

Accepted Answer

A) True 
 B)False

Question 2

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

Accepted Answer

A) True 
 B)False

Question 3

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

Accepted Answer

A)  Export 
B)  Import & Link 
C)  External Data 
D)  Internal Data 
A)  Export 
B)  Import & Link 
C)  External Data 
D)  Internal Data

Question 4

The ____________________ window will return the results of the function based on the values you enter.

Accepted Answer

The answer of The ____________________ window will return the results...

Question 5

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

Accepted Answer

A)  saves the table 
B)  saves the table and exits Access 
C)  copies and pastes the changes into Datasheet view 
D)  runs an update query 
A)  saves the table 
B)  saves the table and exits Access 
C)  copies and pastes the changes into Datasheet view 
D)  runs an update query

Question 6

Match between columns
                        Premises: Before running these queries, check the data types and fields in both tables.

Accepted Answer

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

Question 7

When you create a form, it contains one section called the Title section.

Accepted Answer

A) True 
 B)False

Question 8

The word append means to ____.

Accepted Answer

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

Question 9

A(n) embedded query can be part of another object, such as a command button.

Accepted Answer

A) True 
 B)False

Question 10

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

Accepted Answer

A)  External Data 
B)  Export 
C)  Internal Data 
D)  Import 
A)  External Data 
B)  Export 
C)  Internal Data 
D)  Import

Question 11

You deselect the Allow Full Menus feature so that ____ not displayed.

Accepted Answer

A)  most of the Ribbon is 
B)  all of the Ribbon is 
C)  most of the forms are 
D)  all of the forms are 
A)  most of the Ribbon is 
B)  all of the Ribbon is 
C)  most of the forms are 
D)  all of the forms are

Question 12

Charts are simple to make and format.

Accepted Answer

A) True 
 B)False

Question 13

Using both parameters and wildcards allows you to enter only the criterion that you are sure of in the provided message box.

Accepted Answer

A) True 
 B)False

Question 14

Comments appear in ____ in the macro window, making them easy to identify.

Accepted Answer

A)  red 
B)  blue 
C)  turquoise 
D)  green 
A)  red 
B)  blue 
C)  turquoise 
D)  green

Question 15

Defining a function in a module makes it inaccessible elsewhere in the database.

Accepted Answer

A) True 
 B)False

Question 16

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

Accepted Answer

A)  Eric cannot change the name. 
B)  In the calculated field, double-click the text Expr1, type the new text, and press the Tab key. 
C)  In the formula bar, double-click the text Expr1, type the new text, and enter Ctrl+Enter to replace the text. 
D)  None of the above 
A)  Eric cannot change the name. 
B)  In the calculated field, double-click the text Expr1, type the new text, and press the Tab key. 
C)  In the formula bar, double-click the text Expr1, type the new text, and enter Ctrl+Enter to replace the text. 
D)  None of the above

Question 17

Match between columns
                        Premises: Accepts monetary values and displays them with a dollar sign and decimal point.

Accepted Answer

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

Question 18

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

Accepted Answer

A)  click the row selector and drag the row to a new location 
B)  click the field selector and drag the column to a new location 
C)  copy and append the column into its new location 
D)  freeze the columns and then transfer the data manually 
A)  click the row selector and drag the row to a new location 
B)  click the field selector and drag the column to a new location 
C)  copy and append the column into its new location 
D)  freeze the columns and then transfer the data manually

Question 19

The label typically appears either above or ____ the text box.

Accepted Answer

A)  to the left of 
B)  to the right of 
C)  under 
D)  on top of 
A)  to the left of 
B)  to the right of 
C)  under 
D)  on top of

Question 20

When you run a query, the data in the table on which the query is based no longer exists in the table.

Accepted Answer

A) True 
 B)False

Access prevents you from using parameters and wildcards in the same query.

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

The ____________________ window will return the results of the function based on the values you enter.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

When you create a form, it contains one section called the Title section.

The word append means to ____.

A(n) embedded query can be part of another object, such as a command button.

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

You deselect the Allow Full Menus feature so that ____ not displayed.

Charts are simple to make and format.

Using both parameters and wildcards allows you to enter only the criterion that you are sure of in the provided message box.

Comments appear in ____ in the macro window, making them easy to identify.

Defining a function in a module makes it inaccessible elsewhere in the database.

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

The label typically appears either above or ____ the text box.

When you run a query, the data in the table on which the query is based no longer exists in the table.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

Access prevents you from using parameters and wildcards in the same query.

To insert a new field between two existing rows in a table, click the row selector for the row above where you want the new field to appear.

To import data and create a new table, click the External Data tab on the Ribbon, and then click the Text File button in the ____ group.

The ____________________ window will return the results of the function based on the values you enter.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

When you create a form, it contains one section called the Title section.

The word append means to ____.

A(n) embedded query can be part of another object, such as a command button.

When you need to export data from a database table to an Excel workbook, click the ____ tab on the Ribbon, and then click the Excel button in the Export group.

You deselect the Allow Full Menus feature so that ____ not displayed.

Charts are simple to make and format.

Using both parameters and wildcards allows you to enter only the criterion that you are sure of in the provided message box.

Comments appear in ____ in the macro window, making them easy to identify.

Defining a function in a module makes it inaccessible elsewhere in the database.

Case AC 3-2 Eric is learning how to create calculated fields. Eric notices that Access named the first expression in his query "Expr" and a number (in this case, 1) to indicate the first expression in the query. What can Eric do to change this name?

Case AC 1-2 Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

The label typically appears either above or ____ the text box.

When you run a query, the data in the table on which the query is based no longer exists in the table.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters