MS ACCESS

MICROSOFT OFFICE ACCESS

by Audie Mar Agpawa

Multiple Choice

Question 1: Each column in the database table is a

• Form

• Query

• Record

• Field

Multiple Choice

Question 2: Access is a _______program

• Spreadsheets

• Word Process

• Database Management

• Desktop Publishing

Multiple Choice

Question 3: Each row in a database table is a

• Record

• Field

• Report

• Filter

Multiple Choice

Question 4: This database object is arranged in rows and columns and looks similar to an Excel worksheet.

• Form

• Query

• Report

• Table

Multiple Choice

Question 5: It is best to have a purpose statement before designing a database.

• True

• False

Multiple Choice

Question 1: A query can include fields from more than one table

• True

• False

Multiple Choice

Question 2: Columns are horizontal

• True

• False

Multiple Choice

Question 3: DBMS is use to duplicate a data

• True

• False

Multiple Choice

Question 4: If we are using Queries it always show all the tables.

• True

• False

Multiple Choice

Question 5: What data type could you use for a field when user needs to input a price?

• Number

• Yes/No

• Currency

• Date/Time

Multiple Choice

Recap #1: A good database design helps ensure that your data is what?

(Pick one answer.)

• Always backed up.

• Complete and accurate.

• Duplicated so it’s easier to find

Multiple Choice

Recap #2: What is the function of a primary key? (Pick one answer.)

• To uniquely identify each record in a table.

• To encrypt and decrypt your database.

• To help ensure you enter data in the correct table.

Multiple Choice

Recap #3: How many tables should a well-designed database contain? (Pick one answer.)

• As many as necessary to capture all your data without redundancy.

• One, with many fields.

• Two

• Three