Access part1

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

-A report is a formatted printout of one or more tables or queries. -A report shows each field in a column. -A report in Print Preview shows how the report will look when printed.

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.

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

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

To sort the records in a query datasheet by a field named SalesDate, which of the following buttons can you click? Select all the options that apply.

-Descending button on the Home tab -Ascending button on the Home tab

Arrange the controls for easy data entry.

-Field Name -Field Size -Data Type

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

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

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

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

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

-Next record button -TAB key -DOWN ARROW key

Which of the following are Access data types? Select all the options that apply.

-Number -Date/Time -Currency

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

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

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

-field names -field properties -data types

Which of the following are Access objects?

-forms -reports -queries

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

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

False

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

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

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

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 navigate to the first record in a form, first switch to Form 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 create a table in Table Datasheet view, Access assigns the name PrimaryID to the first field, which you must rename.

False

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

False

When you import Excel data, you create a link to the data in the Access database.

False

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

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

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

Referential integrity

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

_____ 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

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

True

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

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

The Import Spreadsheet Wizard helps you import Excel data into Access.

True

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

True

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

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 can create a table in Table Datasheet view or Table Design view.

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

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

column heading

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 category of data such as a customer's name, city, state, or phone number is called a _____.

field

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

Which field is always on the "one" side of a one-to-many relationship between two tables?

primary key field

Characteristics, such as Field Name and Data Type, are_____ that define a field.

properties

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

The goal of building one-to-many relationships between tables is to minimize _____ data.

redundant

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

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

table

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

If you move the City column in a table datasheet, _____.

you change the appearance of the table but not the structure