Access Chapter 1 Review – Flashcards

Access is a _____.

A(n) _____ contains information about a given person, product, or event.

In Access, table and field names can be up to _____ characters in length

A field whose data type is ____ can store and OLE object, which is an object linked to or embedded in the table.

A field whose data type is ____ can contain any characters.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as a new record is added.

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a _____.

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

To define and additional field in Datasheet view, click the ____ column heading.

To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut menu.

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ___ on the shortcut menu.

In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number field indicates that Business Analyst Number is the ____ for the table.

In the accompanying figure, the small box or bar to left of each field is called the ____.

To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu.

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

To import data to a table, click the ___ tab on the Ribbon.

To save the changes to the layout of a table, click the Save Button on the ____.

To create a Query Wizard, click ___ on the Ribbon and then click the Query Wizard button.

To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the shortcut menu.

To change the design of a query, right-click the query in the Navigation pane and then click ___ on the shortcut menu.

To create and initial report that can be modified in Layout view, click ____ on the Create tab.

To rename a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.

In Access, the rows in a table are called records.

A unique identifier also is called a record key.

Redundancy is the storing of a piece of data in more than one place.

In Access, table names cannot contain digits.

The maximum number of characters allowed in a field whose data type is Text is 255 characters.

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

The Currency data type is used for fields that contain only monetary data.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters ma exceed 225

When Access first creates a database, it automatically creates a table.

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Green computing involves reducing the environmental waste generated when using a computer.

Landscape orientation means the printout is across the length (height) of the paper.

Form view displays a single record at a time.

Report view shows a report on the screen and allows the user to make changes to the report.

The rows in the tables are called _____.

A(n) ______ contains a specific piece of information within a record.

A unique identifier also is called a(n)______.

In the accompanying figure, the ______ Pane contains a list of all the objects in the database.

In the accompanying figure, the entire area that displays on the screen is called the _____ work area.

In the accompanying figure, the database name, Camashly Design appears on the ______.

In the accompanying figure, the buttons at the bottom-right edge of the screen are _____ buttons, which you use to change the view that is currently displayed.

_____ view has more functionality for creating a table than Datasheet view.

If it is desirable to have a name other than a field name appear at the top of a column in Datasheet view, change the field's _____ to a different name.

For the currency data type, Access automatically sets the _____ to Currency.

In ______, the table is represented as a collection of rows and columns called a datasheet.

To move between the upper pane and the lower pane in the Table Design window, press ______ on the keyboard.

The rows in the tables are called _____.