Access Unit A

"Focus" refers to which data you would edit if you started typing. True/False

True

A subdatasheet shows the records on the "many" side of a one-to-many relationship. True/False

True

A group of related fields, such as all the demographi informatoin for one customer, is called _____. A. Record B. Table C. Database D. Object

A. Record

_____ View provides the most options for defining fields. A. Table Design B. Table Creation C. Field Definition D. Definition

A. Table Design

Which of the following is NOT a data type? A. Number B. Formula C. Data/Time D. Short Text

B. Formula

Which data type stores Web addresses? A. Lookup Wizard B. Hyperlink C. URL D. HTML

B. Hyperlink

Tables, queries, and forms are examples of Access ____. A. Entities B. Objects C. Values D. Controls

B. Objects

Which of the following is NOT available to you as you start Access? A. Opening an existing database. B. Re calibrating an existing database. C. Creating a new database from a template. D. Creating a new blank database.

B. Re calibrating an existing database.

A specific category of data suck as a cusomer's name, city, state, or phone number is called _____. A. Object B. Record C. Field D. Tabel

C. Field

Which is NOT true about Access? A. It can be used to create forms. B. It relates lists of information in a relation database. C. Reporting is limited to 20 saved reports. D. Multiple users can simultaneously enter and update within Access.

C. Reporting is limited to 20 saved reports.

Which Access object contains all of the raw data within the database? A. Query B. Form C. Table D. Module

C. Table

Which data type stores only one of two values? A. Attachment B. Hyperlink C. Yes/No D. Null

C. Yes/No

Which data type is used for sequential integers controlled by Access? A. Hyperlink B. Web C. Lookup Wizard D. AutoNumber

D. AutoNumber

Which is NOT a feature of Access reports? A. Headers B. Footers C. Calculations on groups of records. D. Easy-to-use data entry screen.

D. Easy-to-use data entry screen.

An Access database is limited to a size of 1 gigabyte. True/False

False

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended. True/False

False

The navigation buttons on a datasheet display the total number of fields in the datasheet. True/False

False

A primary key field uniquely identifies each record. True/False

True

Field properties change depending on the data types of the field. True/False

True

More than one person can be entering, updating, and using an Access database at the same time. True/False

True

No two records can have the same value in the primary key field. True/False

True

Press [Esc] once to undo a change to the current field. True/False

True

Pressing [Ctrl][;] will insert the current data in a Date field. True/False

True

Tables contain all of the data in the database. True/False

True

The [F2] key switches between Edit and Navigation modes. True/False

True

The linking field on the "many" side of a one-to-many relationship is called the foreign key field. True/False

True

Values in an AutoNumber field are automatically created by Access. True/False

True

Which data type links files created in other programs suck as pictures or documents? A. Lookup B. Attachment C. Yes/No D. Link Wizard

B. Attachment

Which Access object provides an easy-to-use data entry screen? A. Macro B. Form C. Table D. Module

B. Form

Microsoft Access can best be described as _____ software. A. Spread sheet B. Presentation C. Database D. Systems

C. Database