Qustions:  The content and application of the Search tool CANNOT be retained when you ______.  

Answer : close an object

Qustions: The Search tool CANNOT be used on which major Access object?

Answer : Reports
Qustions: In a table, ______(s) are displayed in the order in which they were entered.

Answer : record

Qustions:  The ______ is a wild card that represents one or more characters.

Answer : asterisk
Qustions: Which is not an option for Filter on a text field?

Answer : Between
Qustions:  The Search tool is best used when searching for ______ data.

 Answer :simple
Qustions:  Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?

Answer : Match: Start of Field
Qustions:  Which of the following functions CANNOT be used in the Totals row?

Answer :Round

Qustions: Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.

Answer : Print Preview

Qustions: What is the keyboard shortcut to move to the last records in a table?

Answer :[Ctrl]+[End]

Qustions: A ____ is a major database object used to display information in an attractive, easy-to-read screen format.

Answer : form
Qustions:  Print options can be changed in the Print ____.

Answer :dialog box

Qustions:  Which major database object stores all data?

Answer :Table

Qustions:  The insertion point looks like a(n) ____.

Answer : I-beam

Qustions:  Access file operations can be found by clicking the ____.

Answer :Office Button
Qustions:  A ____ is a major database object used to display information in a printable page format.

 Answer :report

Qustions: In Datasheet View, new records are added to a table ____.

Answer : at the end of the table
Qustions: What happens when a user selects a record in a form and presses [Delete]?

Answer : The record is deleted in the form and from its source table.
Qustions:  Which of the following CANNOT be done to data using a Form?

Answer : Store
Qustions: What is one of the advantages for using a form over other Access objects?

Answer : Utilizes field placement to improve the efficiency of data entry.
Qustions:  Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

Answer :Press [Ctrl]+[+] and [Ctrl]+[-].
Qustions: A(n) ____ in the Record Selector indicates a new record.

Answer : asterisk
Qustions: All attachment fields display as a(n) ____ in Datasheet View.

Answer : paperclip

Qustions: Which of the following methods CANNOT be used to delete records from a table?

Answer : Pressing [Ctrl]+[\’]
Qustions:  Where can you find the undo command in Access?

Answer : Quick Access toolbar

Qustions: An application that executes on separate PCs like this is called a(n) __________ application.

Answer : distributed
Qustions: The most popular commercial DBMS.

Answer : Oracle

Qustions: The ability of a database to grow as the data tracking needs grow is its __________.

Answer :  scalability
Qustions: The most open source DBMS.

Answer : MySQL
Qustions: A DBMS that runs on many different operating systems is said to be __________.

Answer : platform independent
Qustions: Search engines use a(n) __________ to automatically index sites.

Answer :  enterprise
Qustions: The __________ performs document tracking.

Answer : EDM software

Qustions: An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.

Answer : 3-tier
Qustions:  __________ is the clear leader for personal databases.

 MySQL

Qustions: The __________ is the software tool to store or access data.

Answer : DBMS
Qustions:  __________ are documents that when filled in create records.

Answer :  Forms
Qustions: This database has only one table.

Answer : flat-file
Qustions: The __________ field is used to hold a yes or no answer.

Answer : logical

Qustions: To delete records or perform calculations on a table, the best tool to use is a __________.

Answer : query
Qustions:  __________ is used to build ‘intuitive’ queries.

Answer :  QBE
Qustions:  To print information from a table, the __________ tool is the best choice.

Answer : report
Qustions: To store your picture in a database requires a(n) __________ field.

Answer : BLOB
Qustions: The __________ is used to access one record at a time.

Answer :  form
Qustions: SQL stands for __________.

Answer : Structured Query Language
Qustions:  Which of the following creates a drop down list of values to choose from?

Answer : Lookup wizard

Qustions: The command center of access file that appears when you create or open the MS Access database file.

Answer :  Database window
Qustions:  In a database table, the category of information is called __________

Answer : Field
Qustions: It is an association established between common

Answer : Relationship