Exam 19: Implementing a Database With Microsoft Access

Individuals seeking employment today have a competitive advantage if they have knowledge of database management system software.

To change the structure of a relation (table or file),what needs to be open in Microsoft Access?

Microsoft Access's data manipulation subsystem is used to enter and change information and build queries.

Microsoft Excel is the most popular database management system software.

When you establish relationships between the primary and foreign key,Access can enforce integrity constraints and disallow inconsistent information being entered.

The _____ includes a description of each relation and each piece of information in each relation.

When viewing a report where information in a field has been cut off,it is said to be ____.

Where does the information about a field (e.g. ,size,type,decimals)get stored in Microsoft Access?

The data dictionary contains the _____ structure for the information in a database.

After typing in the appropriate information into each field,what key can be used to get to the next field?

Before you can create relationships between the primary and foreign keys in different tables,you must ensure that all the tables are closed.

Before you can enter information into a database system,you must first create the structure of the database by creating its data dictionary and then define the correct structure of the database.

When generating a new report,within which screen is the Summary Option button located?

What is the name of Microsoft's database management system software?

Which of the following phrases would indicate that you are entering information into a database table?

When creating a query in Query Design,you can drag and drop the fields that you want in the query results into the QBE ____.

Using both Order Number and Product Code together as a primary key for an order entry system,eliminates what type of relationship?

In a database management system,the word relation is also called a(n)_____ or file.

If you want to place the date at the bottom of each page (Page Footer)of a report,the command "=TODAY(0)" is used.

There are two main ways to create the data dictionary for e relation: in ______;and in ____.