Exam 11: The Four Main Database Objects

Databases are used for operational processing and for analytical purposes.

A table organizes data in ________ and rows.

When you create relationships in a relational database,you give it power.

To view a form and the data,click ________ view.

A DBMS and database are synonymous.

An extra copy of a database is called a(n)________ database.

Because there are many Access functions that use a table and will not work if the table is open,it is best practice to close a table when you are finished working with it.

A column or field in an Access table is also known as a(n)________.

Query results can be printed from the ________ tab.

To print query results,click the ________ tab.

All of the following can be performed in Excel EXCEPT:

A table organizes data in columns and rows.

Access includes a ________ to make it easier to find objects in a larger database.

A(n)________ pulls records from a table in an easy-to-read format suitable for printing.

A ________ is used to ask a question of the data.

Every time Joe's customers purchase an item,he stores the sale in a database.The best option for him is to use an analytical database.

The process of copying data from another file into a database is known as ________.

A(n)________ is a specific piece of information that is stored in every record.

A form pulls records from a table in an easy-to-read format suitable for printing.

The Navigation ________ makes it easy for you to move through records in a table.