Question 1

_____ view provides the most options for defining fields.

Accepted Answer

A)  Field Create 
B)  Field Define 
C)  Table Create 
D)  Table Design 
A)  Field Create 
B)  Field Define 
C)  Table Create 
D)  Table Design

Question 2

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

Accepted Answer

A)  index 
B)  blank string 
C)  validation text 
D)  zero-length string 
A)  index 
B)  blank string 
C)  validation text 
D)  zero-length string

Question 3

A group of related fields, such as all the demographic information for one customer, is called a _____.

Accepted Answer

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

Question 4

To move a field in the query design grid, click its_____, and then drag it left or right.

Accepted Answer

A)  field tag 
B)  field key 
C)  field string 
D)  field selector 
A)  field tag 
B)  field key 
C)  field string 
D)  field selector

Question 5

When you enter new records, you add them to the end of the datasheet.

Accepted Answer

A) True 
 B)False

Question 6

How can you enlarge the Detail section of a form in Form Design view?

Accepted Answer

A)  Drag the top edge of the Detail section up. 
B)  Double-click the Detail section bar. 
C)  Right-click the Detail section, and then click Resize on the shortcut menu. 
D)  Drag through the horizontal ruler. 
A)  Drag the top edge of the Detail section up. 
B)  Double-click the Detail section bar. 
C)  Right-click the Detail section, and then click Resize on the shortcut menu. 
D)  Drag through the horizontal ruler.

Question 7

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

Accepted Answer

A)  sort orders 
B)  listings 
C)  layouts 
D)  criteria 
A)  sort orders 
B)  listings 
C)  layouts 
D)  criteria

Question 8

If you move a text box in Form Design view, you _____.

Accepted Answer

A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box 
A)  move the other text boxes in the column 
B)  move the label associated with that text box 
C)  must reset the margins of the form 
D)  change the tab order of the text box

Question 9

How can you create a backup of a macro?

Accepted Answer

A)  Use the Backup command in Backstage View. 
B)  Use the Backup command in Action Catalog. 
C)  Convert it to a report in the Navigation Pane. 
D)  Copy and paste a macro in the Navigation Pane. 
A)  Use the Backup command in Backstage View. 
B)  Use the Backup command in Action Catalog. 
C)  Convert it to a report in the Navigation Pane. 
D)  Copy and paste a macro in the Navigation Pane.

Question 10

Which field is always on the "one" side of a one-to-many relationship between two tables?

Accepted Answer

A)  primary key field 
B)  foreign key field 
C)  AutoNumber field 
D)  first field in Table Design view 
A)  primary key field 
B)  foreign key field 
C)  AutoNumber field 
D)  first field in Table Design view

Question 11

What property should you set to have the Department header section appear at the top of every printed page?

Accepted Answer

A)  Repeat Section 
B)  Print Section 
C)  Every Page 
D)  After Section 
A)  Repeat Section 
B)  Print Section 
C)  Every Page 
D)  After Section

Question 12

Characteristics, such as Field Name and Data Type, are_____ that define a field.

Accepted Answer

A)  descriptions 
B)  definitions 
C)  properties 
D)  formats 
A)  descriptions 
B)  definitions 
C)  properties 
D)  formats

Question 13

You primarily use the Form Wizard to create a form to _____.

Accepted Answer

A)  print but not edit database content, 
B)  enter and update data 
C)  answer questions about the information in the database 
D)  automate repetitive tasks 
A)  print but not edit database content, 
B)  enter and update data 
C)  answer questions about the information in the database 
D)  automate repetitive tasks

Question 14

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

Accepted Answer

A)  Store the database in a trusted folder. 
B)  Change the Enable Content startup option. 
C)  Split the database. 
D)  Compact and repair the database. 
A)  Store the database in a trusted folder. 
B)  Change the Enable Content startup option. 
C)  Split the database. 
D)  Compact and repair the database.

Question 15

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Accepted Answer

A)  security 
B)  exclusive mode 
C)  window design 
D)  startup 
A)  security 
B)  exclusive mode 
C)  window design 
D)  startup

Question 16

Before using the Chart Wizard, you should plan which fields you want the chart to display.

Accepted Answer

A) True 
 B)False

Question 17

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

Accepted Answer

A)  Top/Left 
B)  Detail 
C)  Custom Order 
D)  Auto Order 
A)  Top/Left 
B)  Detail 
C)  Custom Order 
D)  Auto Order

Question 18

When you create a report using the _____, Access includes all the fields in the selected table.

Accepted Answer

A)  Report tool 
B)  Report Wizard 
C)  Blank Report tool 
D)  Report Design tool 
A)  Report tool 
B)  Report Wizard 
C)  Blank Report tool 
D)  Report Design tool

Question 19

When you single step a macro, you _____.

Accepted Answer

A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument 
A)  create the macro with one action 
B)  run the macro one action at a time 
C)  record the macro as you perform steps 
D)  add an action with only one argument

Question 20

What kind of criteria would you use to find records with no OrderDate values?

Accepted Answer

A)  IS NULL 
B)  PLUS 
C)  AND 
D)  OR 
A)  IS NULL 
B)  PLUS 
C)  AND 
D)  OR

_____ view provides the most options for defining fields.

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

A group of related fields, such as all the demographic information for one customer, is called a _____.

To move a field in the query design grid, click its_____, and then drag it left or right.

When you enter new records, you add them to the end of the datasheet.

How can you enlarge the Detail section of a form in Form Design view?

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

If you move a text box in Form Design view, you _____.

How can you create a backup of a macro?

Which field is always on the "one" side of a one-to-many relationship between two tables?

What property should you set to have the Department header section appear at the top of every printed page?

Characteristics, such as Field Name and Data Type, are_____ that define a field.

You primarily use the Form Wizard to create a form to _____.

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Before using the Chart Wizard, you should plan which fields you want the chart to display.

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

When you create a report using the _____, Access includes all the fields in the selected table.

When you single step a macro, you _____.

What kind of criteria would you use to find records with no OrderDate values?

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 1: Access 2019

_____ view provides the most options for defining fields.

A(n) _____ is an intentional "nothing" entry, which you might use for employees who do not want their email addresses stored in the database.

A group of related fields, such as all the demographic information for one customer, is called a _____.

To move a field in the query design grid, click its_____, and then drag it left or right.

When you enter new records, you add them to the end of the datasheet.

How can you enlarge the Detail section of a form in Form Design view?

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

If you move a text box in Form Design view, you _____.

How can you create a backup of a macro?

Which field is always on the "one" side of a one-to-many relationship between two tables?

What property should you set to have the Department header section appear at the top of every printed page?

Characteristics, such as Field Name and Data Type, are_____ that define a field.

You primarily use the Form Wizard to create a form to _____.

How can you prevent the security warning with the Enable Content button from appearing when you open an Access database?

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Before using the Chart Wizard, you should plan which fields you want the chart to display.

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

When you create a report using the _____, Access includes all the fields in the selected table.

When you single step a macro, you _____.

What kind of criteria would you use to find records with no OrderDate values?

Excel 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters