ITE Access module 1

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

Access provides data-entry forms. Access allows more than one user to enter data at the same time. Access minimizes duplicate data.

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Access removes all changes to the record.

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

AutoNumber

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

What Access tool can you use to enter dates in a Date/Time field?

Calendar Picker

Which of the following are examples of changing a table's design? Select all the options that apply.

Change a field's data type. Rename a field in the table. Add a field to the table.

Use the _____ to exit Access.

Close button

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

Close the database.

Which of the following options are available to you when you start Access? Select all the options that apply.

Create a database from a template. Create a new blank database. Open an existing database.

What can you do with the navigation buttons on a datasheet? Select all the options that apply.

Create a new blank record. Move the focus to the next record. Move the focus to the first record.

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

DOWN ARROW

Which of the following techniques can you use to navigate to the next record in a datasheet? Select all the options that apply.

DOWN ARROW key TAB key Next record button

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

Date/Time

Which of the following are tasks you perform when creating tables? Select all the options that apply.

Define the fields in the table. Select a data type for each field. Name the table.

Which of the following is the fastest way to open an Access database?

Double-click the database icon.

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

False

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

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

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

False

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

False

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

False

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

False

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

False

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

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 of the following are properties you can set for a field? Select all the options that apply.

Field Name Field Size Default Value

Which two properties are required for every field?

Field Name and Data Type

Which data type stores web addresses?

Hyperlink

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.

Which of the following is a best practice when you are creating a table containing employee names?

Separate the first and last names into two fields.

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

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

Table1

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

Tell Me box

What happens when you close a module?

The Visual Basic window closes.

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

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

A new blank desktop database includes one table named Table1.

True

For a Comments field that contains many words, set a Long 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 close an Access module, you must close the Visual Basic Editor.

True

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

True

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

True

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

True

You use the Report tool to quickly create a report based on the selected table.

True

Which data type stores only one of two values?

Yes/No

Which of the following statements describe a query datasheet? Select all the options that apply.

You can sort and filter a query datasheet. You can edit the records in a query datasheet. You can display a subset of records and fields from a table in a query datasheet.

What is the result of using an Application Part to create a form?

a blank form with controls in a specified layout

Which of the following are features of Access reports? Select all the options that apply.

calculations on groups of records headers footers

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

column heading

When you _____ a database, you reduce the size of the database by up to 75 percent.

compact and repair

Each item on a form is called a _____.

control

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

datasheet

Which type of template creates a traditional Access database?

desktop database

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

does not reuse the value

Which of the following can you define in Table Datasheet view? Select all the options that apply.

field properties field names data types

The _____ refers to the data you would edit if you started typing.

focus

Which of the following are Access objects?

forms reports queries

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

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

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

table

What is the main purpose of a form?

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