Access Simplified Quiz

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

• Email

• 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