Question

• • If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____.
• . a. . sort order
• . b. . tab order
• . c. . form layout
• . d. . focus grouping
  
  

  

• • What do you change when you drag the right border of a form in Form Design view?
• . a. . the layout of the form
• . b. . the width of the form
• . c. . the margins of the form
• . d. . the width of all the form controls
  
  

• • If you set the Caption property of a form, where does the caption text appear?
• . a. . in the Navigation Pane
• . b. . in the form header
• . c. . on the form tab in Form view
• . d. . in the Details section in Form Design view
  
  
  
     

• You can use the arrow keys to move a selected control in Report Design view.
  
  True
  False
  

   

• • To change the column layout in a report in Report Design view, you use the _____.
• . a. . Layout property
• . b. . Columns control
• . c. . Page Setup dialog box
• . d. . Control Layout options on the Arrange tab
  
  
  • An aggregate function is _____.
• . a. . a mathematical expression, such as [Qty]*[UnitsSold]
• . b. . a way to group records, such as by state or postal code
• . c. . a way to test the accuracy of data
• . d. . a function that calculates a statistic such as a subtotal or average
  
  
     

• • If you _____ in the Form Wizard, you can create a form with a subform.
• . a. . sort the records based on more than one field
• . b. . select the tabular form layout
• . c. . select fields from a single table
• . d. . select fields from related tables
  
  
  • You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.
    
    True
    False
    
    

• • The keyboard shortcut for Undo is _____.
• . a. . CTRL+U
• . b. . CTRL+Y
• . c. . CTRL+Z
• . d. . CTRL+W
  
  

• _____ means to connect data in an external file to an Access database.
• . a. . Merging
• . b. . Encrypting
• . c. . Linking
• . d. . Exporting
  
  
    

• • Each item on a form is called a _____.
• . a. . text box
• . b. . control
• . c. . layout
• . d. . property
  

• • A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.
• . a. . form
• . b. . control layout
• . c. . report
• . d. . theme
  

• In Table Design view, "State must be AZ or CO" is an example of integrity text.
  
  True
  False
  
    

• In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.
  
  True
  False
  
  

• • To select more than one control in Form Design view, you _____ and then click each control.
• . a. . press and hold the SHIFT key
• . b. . press the INSERT key
• . c. . press the ENTER key
• . d. . press and hold the ALT key
  

• • In large datasheets, you can ____ certain fields so that they remain on the screen at all times.
• . a. . hide
• . b. . duplicate
• . c. . freeze
• . d. . format
  
  
  • Which of the following layouts can you use to arrange form controls?
• . a. . stacked
• . b. . padded
• . c. . circular
• . d. . horizontal
  
  
  • If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?
• . a. . names that start with D and end with n, such as Dean
• . b. . names that end with n, such as Leon
• . c. . names that start with D and include n anywhere else, such as Donald
• . d. . names that start with D, such as Drew
  
  • You use the _____ to create a query that finds records in one table that do not have related records in another table.
• . a. . Crosstab Query Wizard
• . b. . Select Orphans Query Wizard
• . c. . Find Unmatched Query Wizard
• . d. . Find Duplicates Query Wizard
  

  

• If you do not enter a Caption property for a field, Access uses the field name to label the field.
  
  True
  False
  
  

Answer 1

Note: As per the Chegg policy in case of multiple questions only first four sub-part can be answered. Thanks

1. Tab order (b)

Explanation: Tab order is used to set the order of focus on a control inside the Form. You will set Tab order using Tab Index. It starts from Tab Index 0 and when you press tab it will move to the control which have next Tab Index which is 1 and so on.

2. Width of the form (b)

Explanation: Design view is used for actual design of the form so when you drag the right border of a form it changes the width of the form.

3. In the form Header (b)

Explanation: when Caption is set, It is displayed in form Header as below:

4.True

Explanation:When you select the control, using Arrow (Directional keys) you can move selected control on the form every where.