Exam 2: Access: Introduction to Powerpoint

Which of the following views would you use to view or modify a table's structure?

Microsoft SSL Server is an example of an advanced DBMS.

What database object is an electronic version of the paperwork you fill out at the doctor's office?

Searching a website to help you find just the right product involves database technology.

To create a database from a template you would use which view?

Match the following terms with their description: i. Compact and Repair Database II. Database III. Datasheet view IV. Design view v. Module

A ________ is a stored series of steps or commands.

Most users enter information into a database through the use of a ________.

Match the following terms with their description: i. Form II. Report III. Macro IV. Sort v. Filter

Which of the following is not a valid criteria in a filter?

Match the following with their description: i. <>, =., >, < II. AND, OR, NOT III. Contains "Bill" IV. Tabs Documents interface v. Oracle

Access is a ________ Management System.

Which of the following operators will give you the fewest number of hits?

If you see plus signs (+) next to records in Datasheet view, then you know that two or more tables are related.

Match the following terms with their description: i. Table II. Field III. Record IV. Primary Key v. Query

When you type Smith in a person's last name field you are entering information.

Match the following acronyms with their description: i. VBA II. DBMS III. ACCDE IV. Database v. SQL

DBMS stands for ________.

When first designing a database, it is not important what data type you assign each field because you can easily change it later.

Only the most complex databases have more than one table.