Personal Computer Applications Access Quiz

True

In order to save changes to a database, you must save the objects individually.

unsure

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 below. Aside from First Name and Last Name, what fields must be added to the query? Check all that apply.

Change the table join to right-to-left instead of left-to-right.

Let's say you've created a query to find only customers who have placed orders. But when you run the query below, it returns both customers who have and haven't placed orders. What could you do to fix this?

1 - Forms 2 - Tables 3 - Queries 4 - Reports

Match the following:

Switch to Design View and edit the criteria.

Suppose you created the following query, 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 and Replace feature.

The following table has more than 100 records. You want to change all instances of the phrase "half-dozen" to "baker's dozen." What's the fastest way to do this?

Using a form to create a record

What does the following clip demonstrate?

not - Access handles non-numerical data better than Excel.

Which of the following are advantages of using Access over Excel? Check all that apply.

Reports allow you to present tables and query results in an easy-to-read format.

Why would you want to create a report?

not - Sort the table.

You want to use the table below to find which orders were specifically placed for a party. Which of the following should you do?