DBMS Quiz No. 1

True or False: In order to save changes to a database, you must save the objects individually.

• True

• False

Sets of related data.

• Tables

• Forms

• Queries

• Reports

User-friendly interfaces for entering and viewing data.

• Tables

• Forms

• Queries

• Reports

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

• Tables

• Forms

• Queries

• Reports

Formatted summaries of data suitable for printing

• Tables

• Forms

• Queries

• Reports

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

• Use a text filter on the Notes field

• Use a number filter on the Notes field

• Sort the table

• Create a report

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

• Access handles numerical data better than Excel

• Access handles non-numerical data better than Excel

• Access uses PivotTable to summarize data

• Access is a relational database, which makes it easier to find connections in your data

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 feature to search for Cake

• Switch to design view and edit the criteria

• Delete the query and re-create it

• Use a filter on the Product type field

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?

• Re-type the records

• Use the Find and Replace feature

• Sort the Sales Unit field, scroll to Half-dozen, then use copy and paste

• Apply a filter to the Sales Unit field, then retype the records

What does the following image show?

• Using a form to create a record

• Using a table to create a report

• Creating a query

• Using a form to calculate a field