CGS 2100 Final Exam

When you use a form to enter data, you are actually adding data to the underlying _______.

table

_______ is used to modify the structure of the database object.

Design view

The database ________ store all the data.

tables

You can display all the database relationships at once by clicking the All Relationships button on the _______ tab.

Relationship Tools Design

Reports include _______, which shows how the report will look when printed.

Print Preview

A(n) _______ field is automatically assigned its value by Access. Database users cannot edit or enter data in this field.

AutoNumber

The top pane of the Design view window lists the _______ fields.

table

If the field you are changing is the primary or foreign key in a relationship, Access may _______ before changing the data type.

require you to delete the relationship

The _______ is the field that contains data unique to that record.

 

primary key

If the field you want to change to a lookup field uses the Date/Time or Currency data type, you will need to change the data type to ____________ before you can modify it to be a lookup field.

Number

_______ displays a list of all the unique values in a field.

 

Auto Filter

You can create a select query to find records that are missing data in a particular _______.

field

The Expression Builder can be used to create complex expressions including functions similar to those in _______.

Excel

To find records that meet more than one condition in the same field, enter both criteria separated by the word _______ in the Criteria row.

And

When referencing a field name in an expression, the field name is always enclosed in _______.

brackets

A _______ control displays the field name on the left.

label

The easiest way to create a new report is to use the _______ button.

Report

If you need a version of one of your database objects, particularly reports, to look exactly like it would when printed from Access, consider exporting the object to a(n) _______.

PDF file

To add a new bound control to a form, first click the _______ button to display the Field List pane.

Add Existing Fields

If the printed report will result in _______ page(s), Access will display a warning message when you switch to Print Preview view.

blank

Some fields require a specific input format called a(n) _______.

input mask

To switch to another view, click the _______ tab and then select your view from the View button arrow.

Home

Forms open in _______ view, which provides a user-friendly interface for entering data.

Form

You can control the order in which records appear in a table, query, or form by using the _______ feature.

Sort

Access _______ are the essential building blocks of the database.

tables

The _______ property ensures that users enter data in a particular format. For example, a field for social security numbers can force users to enter numbers in the format 123-45-6789.

Input Mask

To delete a field in Design view, select the field you want to delete by right-clicking the ______ to the left of the field name, and select Delete Rows.

Row Selector

Fields can be inserted at the end of the field list in Design View by typing a new field name and selecting a ________ type.

data

To add a new field to a table in Datasheet view, click the arrow in the _______ column to expand the list of available field types.

Click to Add

_______ the line connecting the tables in the Relationships window to open the Edit Relationships dialog.

Double-click

In a query, a _______ displays a value returned by an expression (a formula).

calculated field

Click the _______ filter option to remove the filter from the field.

Clear

When entering numeric or date criteria, you can enter values for _________ matches, or you can enter an expression using comparison operators to broaden the criteria.

exact

The _______ button on the Home tab will quickly apply or clear filters.

Toggle Filter

When referencing a field name in an expression, the field name is always enclosed in _______.

brackets

Adding _______ organizes a report into sections by the value of a specific field.

grouping

To remove a row or column from the control layout, _______ anywhere in the row or column and select Delete Row or Delete Column.

right-click

Data in the _______ section appears at the bottom of every printed page in a report.

page footer

The _______ walks you step by step through the process of creating a report.

Report Wizard

_______ are the blank spaces at the top, bottom, left, and right of the printed page.

Margins

_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.

Queries

_______ key fields are identified with a key icon next to the field name.

Primary

Although an attachment is not visible in the table, when you start working with _______, the attachment is available for display.

forms and reports

You can change a field name by modifying the _______ properties.

field

The Lookup Wizard is accessible after expanding the _______ in Table Design view.

Data Type list

Sorting query results in ascending order sorts them _______.

from A to Z

To remove a table from the query Design window, _______ the table box header and select Remove Table.

right-click

The Run button is located near the left side of the Ribbon on the Query Tools Design tab, in the ____________ group.

Results

If you want to control how records are displayed, set the _______ order as part of the query design.

sort

The Form button is located in the _______ tab of the Ribbon.

Create

_______ in a report display a calculation such as the sum or average of the values in a field or group.

Totals

Data in the _______ section appears at the very beginning of the report.

report header

_______ display database information for printing or viewing on-screen.

Reports

In Datasheet view, attachment fields are designated by a(n) _______ icon.

paperclip

To delete the relationship between two tables you can _______ the relationship line and select Delete.

right-click

_______ criteria are used for text and hyperlink fields.

Text

If you want to include a field in your query, but do not want that field to show in Datasheet view, click the _______ box to remove the checkmark for the field you want to hide.

Show

The _______ Filter button indicates that a filter has been applied to the query.

highlighted

If you want to include all the fields from a table in your query, click and drag the _______ from the top of the table to the field row.

asterisk (*)

_______ are conditions that the records must meet in order to be included in the query results.

Criteria

To preview more than one page at a time, in the _______ group click the view option desired.

Zoom

A control that displays data from a table or query is called a(n) _______ control.

bound