Access Chapter 1

What is the difference between entering a record using a form and entering a record using a datasheet?

A form presents records one at a time, while a datasheet lists all records.

What happens when you save and close a query?

Access saves the query design.

Which data type is used for sequential integers controlled by Access?

AutoNumber

To back up a database, you use the _____ command.

Back Up Database

What should you do if you want to make a copy of a database in a secure location?

Back up the database.

Which of the following templates lets you create a database from scratch?

Blank desktop database

When viewing a long datasheet, which of the following is the fasted way to move to the end of the datasheet?

Click the Last record button in the navigation bar.

After starting Access, which of the following is the fastest way to open a database you worked on yesterday?

Click the database you want to open in the list of recent databases.

Use the _____ to exit Access.

Close button

What should you do when you are finished working a database?

Close the database.

Which data type works best to store dollar amounts?

Currency

When editing a record, what key can you use to navigate to the next record?

DOWN ARROW

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

Date/Time

When you add a field to a table in Table Design view, the _____ property is optional.

Description

Which key do you press to remove all characters when editing a field value in Table Datasheet view?

ESC

Access provides a single database template for creating a blank database.

False

Database templates create tables and queries, but not forms and reports.

False

On a form, you use Edit view to enter, edit, and delete records.

False

To navigate to the first record in a form, first switch to Form Design view.

False

When you create a table in Table Datasheet view, Access assigns the name PrimaryID to the first field, which you must rename.

False

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

False

You can use a report to enter a record into the database.

False

Which two properties are required for every field?

Field Name and Data Type

In the _____, Access lists each object in the open database.

Navigation Pane

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Save the table.

What data type should you assign to a field that stores postal codes?

Short Text

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Shutter Bar Open/Close button

When you use the _____, Access asks you for the information it needs to create a query.

Simple Query Wizard

Which of the following tools can you use to create a query?

Simple Query Wizard

Which Access object contains all of the data in the database?

Table

What can you use to find information about Access commands and features and instructions about how to use them?

Tell Me box

A field's data type determines what values you can enter for the field.

True

For a field using number values that will not be used in calculations, you should assign the Short Text data type.

True

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

True

To resize a datasheet column to its best fit, you double-click the vertical line to the right of the field name.

True

When using the Report Wizard, you can click the Back button to review previous dialog boxes.

True

You might delete an employee record if the employee no longer works for the company.

True

What is the most efficient way to navigate to the last record in a table containing 100 records?

Use the Last record button on the navigation bar.

Which data type stores only one of two values?

Yes/No

Carrie entered 10/16/21 as the date in a field with the Date/Time data type and the default format. How does Access format the year in the date after Carrie moves to a new field?

as a four-digit year value

Tyler created a table with an AutoNumber primary key field, and then entered 10 records in alphabetic order by the values in the LastName field. When he closes and then reopens the table, how are the records ordered?

by the primary key field

When you _____ a database, you make more storage space available and enhance the performance of the database.

compact and repair

Microsoft Access can best be described as ____ software.

database

A _____ is a grid that displays fields as columns and records as rows.

datasheet

A field with the Currency data type contains values such as quantities, measurements, and scores.

false

After you create a table, you must save the entire database so you do not lose the new table.

false

Before you can rename a field, you must change its data type.

false

Before you close a database, you must save any changes you made to the data.

false

Compacting a database has the same result as backing up a database.

false

Of all the database objects, a table provides the most formatting, layout, and summary options.

false

Press ESC to remove editing changes you made to the previous record.

false

To display the data in a table, you open the table in Table Design view.

false

To navigate to a record in a table, switch to Table Design view.

false

To select fields and records to answer a question, you most likely create a form object.

false

Use the New (blank) record button to move the focus to the first record in a table.

false

When you enter a record in a table, you are working in navigation mode.

false

When you start Access, the first screen that appears is one showing a blank database.

false

A category of data such as a customer's name, city, state, or phone number is called a _____.

field

To rename a field in Table Datasheet view, you change the text in the _____.

first record

A _____ typically shows all the fields for one record on a single screen for data entry and editing.

form

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

modify the report's design

To navigate records in Form view, you use the buttons on the _____.

navigation bar

Tables, queries, and forms are examples of Access ____.

objects

The _____ to the left of a table record indicates that you are editing the record.

pencil symbol

Creating a table in Design view involves entering the field names and defining the _____ for the fields.

properties

You can create an Access report by selecting fields from one or more tables or _____.

queries

A group of related fields, such as all the demographic information for one customer, is called a _____.

record

Each row in a table datasheet displays a _____.

record

In a datasheet, what do you click to select a record for deletion?

record selector button

If you want to manage lists of data about customers and the products they order, use _____ software.

relational database

Besides reducing file size, what other benefit does compacting an Access database provide?

repairing the database

The first step in the Form Wizard is to _____.

select the fields to include in the form

In which object can you rename a field?

table

_____ is the default name for a new table in an Access database.

table1

A _____ is a predesigned database that includes professionally designed tables, reports, and other database objects.

template

What is the main purpose of a form?

to provide an easy-to-use format for entering and editing records

A new blank desktop database includes one table named Table1.

true

Compacting a database rearranges the data and objects in a database to decrease its file size.

true

To learn more about a data type, you can enter the name of the data type in the Tell Me box.

true

You can create a table in Table Datasheet view or Table Design view.

true