question

A database is a collection of objects.

answer

True

question

When you open an existing database, the Navigation Pane opens on the left side of the screen.

answer

True

question

After you delete a record, you can use the Undo command to restore it.

answer

False

question

The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs.

answer

True

question

When you create a blank database, Access creates the first table for you and gives it the name Database1.

answer

False

question

In Design view, you can add, delete, and make changes to the way that fields store data.

answer

True

question

Any changes that you make in Design view are automatically updated in Datasheet view when you save the table.

answer

True

question

The Description property in the design grid is a required field property that you use to describe what to enter in the field.

answer

False

question

A field property describes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store or the allowable values that you can enter in the field.

answer

True

question

A query is a database object that lets you ask the database about the data it contains.

answer

True

question

You must add fields in a certain order to the design grid.

answer

False

question

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

answer

True

question

To add a condition to a field, click in the field's Criteria box, and then type the condition.

answer

True

question

When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.

answer

True

question

You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.

answer

True

question

The 3 sections of a form are the Form Header, Detail, and Form Footer.

answer

True

question

To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.

answer

False

question

The Form Footer section displays information at the top of each form.

answer

False

question

Forms have a Navigation bar that you can use to move between records.

answer

True

question

____ is a program known as a database management system (DBMS).

answer

Access

question

A DBMS is ____ than using file folders to manage data.

answer

more flexible, more accurate, & much faster

question

A ____ selector appears to the left of the first field for each record.

answer

record

question

When you change the row height of a datasheet, the change ____.

answer

affects all the rows in a datasheet

question

When resizing a column, selecting ____ automatically resizes the column to the best width for the data contained in the column.

answer

best fit

question

In ____, you can rearrange the order of the fields in a datasheet by dragging them to a new location.

answer

Datasheet view

question

If you make changes to the layout of a datasheet and try to close the table, Access will ____.

answer

prompt you to save your changes

question

____ a database rearranges how the database is stored on a disk and optimizes the performance of the database.

answer

Compacting

question

Jonathan is preparing a database of his favorite foods which is shown in Figure 1-1. It is his first time using a database and he is becoming familiar with the terminology. Jonathan will be sorting the database on "Specialty," which is a ____.

answer

field selector

question

Jonathan is preparing a database of his favorite foods which is shown in Figure 1-1. It is his first time using a database and he is becoming familiar with the terminology. The word "Italian" is an example of a ____.

answer

field value

question

Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Once Chloe makes the changes in the layout of the datasheet, the edits are saved ____.

answer

only if she saves them

question

Chloe's boss has asked her to make some changes to the layout of a datasheet. She has never done this before, and is learning as she goes along. Chloe needs to move the second column so it becomes the first column. To do this efficiently, Chloe will ____.

answer

click the field selector and drag the column to a new location

question

The first step in creating a database is to create the file that will store the database ____.

answer

objects

question

When you create a blank database, the table that Access creates for you contains one field named ____.

answer

ID

question

The ____ is the field that contains a unique field value for each record in the table.

answer

primary key

question

A field's ____ determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text.

answer

data type

question

The ____ data type stores True/False values.

answer

Yes/No

question

You need to save a table only when you make changes to its layout, such as ____.

answer

resizing columns

question

In ____, you can add, delete, and make changes to the way that fields store data.

answer

Design view

question

Just like when you select a record selector in a datasheet, the record selector for a selected field in the design grid changes color to ____ when the field is selected.

answer

orange

question

The ____ sets the number of characters you can store in a Text, Number, or AutoNumber field.

answer

Field Size property

question

Kristin has put together a list of job candidates for various positions within her company. In Figure 2-1, she needs to confirm the data type for one column and also set the primary key. The Appointment column has field values of the ____ data type.

answer

Date/Time

question

Kristin has put together a list of job candidates for various positions within her company. In Figure 2-1, she needs to confirm the data type for one column and also set the primary key. The ____ field would make the best primary key because there would never be two people with the same data in that field.

answer

ID

question

Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value. He is researching which Access properties will help him with his task. To make sure that a specific field is filled in and has data in it, Sam will use the ____ property.

answer

Required

question

Sam is putting together a database where there are some fields that must be filled in and also some fields where he wants to put in a default value. He is researching which Access properties will help him with his task. To set a default value that will automatically appear for some of the fields, Sam will use the ____ property.

answer

Default Value

question

When you open a query object, you ____ the query.

answer

run

question

An easy way to create a query is to use the ____, which asks you what data you want to see by letting you select options in dialog boxes.

answer

Simple Query Wizard

question

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

answer

Sort & Filter

question

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

answer

Filter By Selection

question

A query can contain ____ of the fields in the table.

answer

one, some, or none

question

You can run the query by clicking the Run button in the ____ group on the Query Tools Design tab.

answer

Results

question

You can use a form to ____.

answer

add new records, delete existing records, or update the record source

question

You must be in ____ view to add controls such as lines, rectangles, and labels to a form.

answer

Design

question

The ____ section displays information at the bottom of each form.

answer

Form Footer

question

Jessica wants to find and replace some data in her database. Please refer to the figure above as you answer the questions below. If Jessica types S in the Find What list box, and then selects the Any Part of Field option in the Match menu, she'll find values that ____.

answer

contain the letter S anywhere in the value

question

Jessica wants to find and replace some data in her database. Please refer to the figure above as you answer the questions below. If Jessica types S in the Find What list box, and then selects the Whole Field option in the Match menu, she'll find values that ____.

answer

contain only the letter S

question

When fields appear in a form, they appear in ____.

answer

controls

question

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into two panes. In the bottom pane, you see a ____ that contains the form data.

answer

datasheet

question

Zack wants to create a custom form to match a paper form that he uses everyday in the office. Please answer the questions below. To create a blank form, Zack needs to click the Create tab on the Ribbon, and then click the Blank Form button in the ____ group.

answer

Forms

question

Zack wants to create a custom form to match a paper form that he uses everyday in the office. Please answer the questions below. Zack has opened the Field List pane and wants to add a field to the form. What should he do?

answer

Double-click a field in the Field List

question

Each record is made up of one or more of these.

answer

fields

question

A complete set of data.

answer

record

question

Used to identify the fields

answer

field name

question

The data entered into a field.

answer

field value

question

Appears at the top of each column in a table and contains the field name.

answer

field selector

question

allows letters and numbers up to 255

answer

Text

question

allows letters and numbers up to 65,535

answer

Memo

question

formats with a $ and a decimal

answer

Currency

question

gives a unique number to each record

answer

AutoNumber

question

allows you to choose a value from a list

answer

Lookup Wizard

question

stores graphics, sounds and objects

answer

OLE Object

question

stores the date or time

answer

Date/Time

question

Shows every field in each record

answer

Detail query

question

Selects records that match at least one of two or more conditions in a query

answer

Or operator

question

Temporarily displays records in a datasheet based on the condition that you specify

answer

Filter

question

Selects records that match two or more conditions in a query

answer

And operator

question

Lets you summarize relevant data, such as adding the field values in a column that stores price data

answer

Summary query

question

The tables or queries that contain the data used in a form

answer

Record source

question

A control that is not connected to a record source and is used to display information, lines, rectangles, and pictures

answer

Unbound control

question

Creates a simple form that includes all the fields in the selected table or query, uses a simple format, and includes a title with the same name as the record source

answer

Form tool

question

A database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form

answer

Form

question

A control connected to a field in the record source and is used to display, enter, and update data

answer

Bound control

Access 1-4

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards