WorksheetsAccess Simplified Quiz
Total questions: 10
Worksheet time: 4mins
Select the four main objects that comprise an Access database.
Charts
Reports
Tables
Forms
Queries
Access is generally used to work with ________ databases.
non-relational
single-row
absolute
relational
True or False: In order to save changes to a database, you must save the objects individually?
True
False
Let's say our bakery wants to create a list of customer names and email addresses for customers who pre-ordered an item and picked it up during the month of
December. The tables needed for the query are shown in this image. Aside from First Name and Last Name, what fields must be added to the query? Select all that apply.
Pickup Date
Pre Order
City
Which of the following best describes a query?
Data resulting from questions you ask of one or more tables
A list of settings that controls who can edit the database
A formatted summary of data suitable for printing
A user-friendly interface for entering and viewing data
True or False: Access only allows one sort per query?
True
False
Suppose you created the query shown in this image, but later you realize that you really wanted to find the total number of cakes sold instead of cookies. What is the best way to solve this problem?
Switch to Design View and edit the criteria
Delete the query and re-create it
Edit the table relationships
Use the Find feature to search for Cake
Suppose you run a query, and a dialog box appears asking you to enter a date. You are most likely working with a ________ query.
dialog
parameter
totals
date & time
Why would you want to create a report?
Reports allow you to present tables and query results in an easy-to-read format
Reports are used to add data collection fields to forms
Reports allow you to export a table as an Excel file
Reports make it easy to add records to a table
If you create a form from a table with records that are linked to another table, the form will automatically include a ________.
subform
totals row
query
button
