Access Blackboard Questions

A Short Text field can hold up to _______ characters.

255

A Long Text field can hold up to _______ characters.

65,535

Click the _______ button to display the Field List pane.

Add Existing Fields

A(n) _______ field can include images, Word documents, or almost any other type of data file.

Attatchment

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

AutoNumber

Access opens to _______ where you can select an existing database to open or begin a new one.

Backstage view

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

Blank

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

Bound

A(n) _______ control is a control that displays the field data.

Bound

In the _______ box, type the field name as it should appear in labels and column headings.

Caption

Instead of preventing updates or deletions when enforcing referential integrity, you can set relationship options to delete or update the related records in the secondary table. These options are known as _______ options.

Cascading

If you want to set up a table without entering data, use the _______ heading at the far right side of the table.

Click to Add

If you are starting with a blank report, you will need to add _______ to display field data.

Controls

A(n) _______ field stores a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal). Access will not round these fields.

Currency

Click and drag the _______ to make a control wider or narrower.

Cursor

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

Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.

Database

Entering a value in the _______ can save time during data entry.

Default Value Property

If you no longer need an object or want to use a different name, Access allows you to _______ and rename forms, reports, and other database objects.

Delete

Access will prevent you from _______ records if it would violate the integrity of the database.

Deleting

Access allows program files (for example, .exe or .bat files) as attachments only if you have administrator privileges in this particular database.

False

Access does not provide any method to sharing or exporting of data to other applications.

False

Access offers database designers only one template for creating forms.

False

Calculated fields can include references to fields in other tables or queries.

False

Each column in a table represents a specific data value called a(n) _______.

Field

In Design view, the bottom pane is the _______ pane which displays details about the selected field.

Field Properties

Access is a relational database—objects in your database are related to one another through relationships defined by common _______ between tables.

Fields

If you need to find multiple records that match your search parameters, not just the first one, use the _______ command.

Find

A(n) _______ displays data from an underlying table and allows database users to enter, edit, and delete data in a user-friendly format.

Form

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

Form view

Expand the _______ list to select from predefined format options for AutoNumber, Number, Currency, and Date/Time data types.

Format

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

Grouping

Access allows three common design elements, a logo or other small image, a title, and the current date and/or time, to be quickly and easily added to the _______ area of a form.

Header

In Datasheet view, the number next to the attachment icon in each record tells you _______.

How many attachments are there

A(n) _______ field stores a Web address or email address.

Hyperlink

A(n) _______ control displays the field name on the left.

Label

Forms and Reports also offer _______ where you can modify some (but not all) structural elements.

Layout view

If you right-click any field name and select Insert Field to insert a new blank text field, it is inserted to the _______ of the field you selected.

Left

A(n) _______ form is similar to a Datasheet form, but it is more flexible since you can easily modify its layout and design.

Multiple Items

In the _______ box, type the new field name. This is the name as it will be referenced by other objects in your database.

Name

All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.

Navigation

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

Although you create and work with a single Access database file, inside the file, there are multiple _______.

Objects

A Single Record Form can be based on either a Table or Query and it displays _______ record(s) at a time.

One

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

Page footer

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

Page header

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

Paperclip

Clicking and dragging to resize controls can be imprecise. Use the _______ if you need to specify an exact width or height.

Property Sheet

Each row in a table contains all the data for a single _______.

Record

A(n) _______ database is a group of tables related to one another by common fields.

Relational

Access will warn you if you try to delete a table that would invalidate _______.

Relationship

If you confirm that you want to delete a table, Access will automatically delete the _______, and then delete the table.

Relationships

Objects in Access are related to one another through _______ defined by common fields between tables.

Relationships

A(n) _______ displays data from a table or query in a format suitable for printing.

Report

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

Report footer

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

Report header

In Access, normally _______ are the only database objects that are printed.

Reports

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

Clicking the _______ button on the Quick Access Toolbar will prompt you to name and save a newly-created table.

Save

A new blank report does not have a record _______ defined until controls are added.

Source

A(n) _______ form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.

Split

Deleting a record in a form will also delete it from the underlying ________.

Table

Access _______ are the essential building blocks of the database.

Tables

By default, blank reports use a _______ layout in which data are arranged similar to a table with the label controls at the top of each column.

Tabular

A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.

Template

A(n) _______ is a unified color and font scheme.

Theme

A form does not contain records or data itself. It is only an interface to an underlying table or query.

True

Access allows you to delete and rename forms, reports, and other database objects.

True

Access is the only Office application that uses a dedicated Print Preview page.

True

All records in a table have the same fields.

True

Duplicates of the primary key field are not allowed.

True

Adding a field to a blank form places _______ control(s) in a stacked layout.

Two

A(n) _______ control is a control that is not linked to a field.

Unbound

If you are working on data entry in the Datasheet view or Form view, the _______ command is applied to the entire record, not each individual field within the record.

Undo

A(n) _______ field stores a true/false value as a -1 or 0.

Yes/No