Access Part 2 Quiz
Name:
*
First Name
Last Name
Email:
*
example@example.com
Spreadsheet ID:
*
Your spreadsheet ID is available in the StudentsExcel Portal: http://portal.studentsexcel.com/.
1. The VLOOKUP function in Microsoft Excel has the following arguments:
*
A. reference, rows, cols, height, width
B. index_num, value1, value2
C. array, row_num, column
D. lookup_value, table_array, col_index_num, range_lookup
2. Which section of a form allows you to display information at the bottom of a screen?
*
A. Form Header
B. Detail
C. Page Footer
D. Form Footer
3. Form buttons appear on which ribbon tab?
*
A. Home
B. Create
C. Database Tools
D. Design
4. The Compact on Close setting is available within which set of options in Access?
*
A. General (or Popular in Access 2007)
B. Current Database
C. Object Designers
D. Client Settings
5. Which SQL command specifies the fields that should appear within query results?
*
A. SELECT
B. FROM
C. WHERE
D. ORDER BY
6. Assuming x is a number of records, adding the TOP clause instructs Access to:
*
A. Return the largest value from a query
B. Return the x largest values from a query
C. Return the first x records from a query
D. Return the last x records from a query
Calculation
Submit
Should be Empty: