Microsoft Access

What is a database?

• A word processing program

• A type of spreadsheet software

• A system for managing data

• A collection of data stored in a file

Select the four main objects that comprise an Access database.

• Forms

• Charts

• Tables

• Reports

• Queries

Access is generally used to work with ________ databases.

• relational

• single-row

• non-relational

• absolute

What is an object in Access?

• A program used to create databases

• A type of spreadsheet software

• A type of query

• A container for related data

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.

• Pre Order

• City

• Pickup Date

• Email

Which of the following best describes a query?

• A list of settings that controls who can edit the database

• Data resulting from questions you ask of one or more tables

• A formatted summary of data suitable for printing

• A user-friendly interface for entering and viewing data

What is a record in Access?

• A collection of related fields

• A type of report

• A type of query

• A container for related tables

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?

• Use the Find feature to search for Cake.

• Switch to Design View and edit the criteria.

• Delete the query and re-create it.

• Edit the table relationships.