Access

Access is a program known as a __________________.

DBMS (database management system)

You can select all of the records and fields in a table datasheet by clicking the ________________,

Data sheet selector

The ______ creates a form that looks just like a datasheet.

Data sheet tool

What is a subdatasheet?

Displays related records in the primary table in a relationship

How do you add all fields from a table to the design grid in the Query Design view in one step?

Double click the table name at the top of the field list, drag the selected fields to the first column.

A common field used to relate tables must have the same field name in the related table. T or F

False

A field with the Text data type an store up to 65,535 characters. T or F

False

If you want to print something only at the bottom of the last page of the report add the content in the page footer section. T or F

False

Pressing and holding down Alt allows you to select more than one column in a data sheet. T or F

False

The multiple items tool creates a form that displays a form and a datasheet in separate panes.T or F

False

The object that stores data in the database is a form. T or F

False

To insert a new field in a table in Design View, first click the row above where you want the new field to appear in the design grid. T or F

False

To remove a filter from a datasheet, click the Cancel Filter button. T or F

False

When a report is displayed in layout view, you can use it to change the date of the report contains. T or F

False

When you click the delete button in the records group in the home tab, the record displayed in form view is deleted. T or F

False

When you use the Report tool to create a report, you can base it on two or more tables. T or F

False

The bottom half of the table window I design view is called the ______ pane.

Field properties

Applying a ______ to the datasheet temporarily displays records based on the condition that you specify.

Filter

When a relationship exists between two tables in a database, what name is given to the matching fields in the related table?

Foreign key

The ______ 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

Form tool

When should you freeze columns in a data sheet?

Freezing columns keeps them displayed on the screen as you scroll.

A______organizes data in a report based on one or more fields.

Grouping level

To move to the first field in the current record, press _____________.

Home

How do you use the report selector to resize a report that contains one or more blank pages when the reporter selector contains a small, green triangle on it?

In design view, click report selector to select the report

List the steps for using the label wizard to create a report based on a table

In navigation pane select, the table or query that contains the dado you want on the labels. click create tab, click labels button, use label wizard to select the label manufacturer and type font name, style, size, and color to the fields to include on the label and their arrangement on the label, also the report name

List the steps for using the report tool to create a report based on a table

In navigation pane, select the table or query that contains the data. Click the create tab then click the report button

The _______________ lists the objects in the current database.

Navigation pane

If you delete a record using a form, is it possible to undo the action? Why or why not?

No. Deleting a record using a form is permanent and can't be undone

The ______data type stores numbers that Kathy be used in calculations.

Number

How do you add fields to a blank form in layout view?

Open the field list pane, if needed double click the fields to add them to the form.

A tables ________ is the field that contains a unique field value for each record in the table.

Primary key

A ______ is a database object that you can use to find answers to questions about the data in a database

Query

The data in a report is______, which means that you can view it but you cannot change it.

Read only

The_____section is printed once at the bottom of the last page of the report, and usually include summary information for the entire report, such as grand totals.

Report footer

The _______creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, formats every other row in the report with the gray color, and includes a title with the same name as the record source.

Report tool

What information do you specify when you run the Simple Query Wizard?

Select one or more tables and/or queries. Select the fields in tables or queries you want to see, choose the option for a detail query or summary query, accept the default query name or enter a new one.

When working in layout view, how do you remove a field from a control layout form?

Select the control, right click the control, point to layout on the shortcut menu, click remove layout

How do you delete a record in Datasheet view?

Select the record and press delete. OR click the delete button in the records group on the home tab.

When you view field values in ascending or descending order from A to Z or from smallest to largest, you apply a ______ to the field.

Sort

The ______ creates a form using all the fields in the selected table or query and splits the window into two panes

Split form tool

The ______data type stores field values with 255 or fewer characters with letters, numbers, spaces, and certain symbols such as an underscore.

Text

To display all records in a datasheet after you applied a filter, click the ______ button.

Toggle filter

A tables primary key might be an AutoNumber Field. T or F

True

Applying a filter is a temporary way of selecting records in a datasheet. T or F

True

Changing the height of one row in a datasheet changes rhe height of all rows. T or F

True

Clicking a record selector in a datasheet selects an entire row. T or F

True

Many database experts agree that updates to the data in a database should be made using forms. T or F

True

Microsoft Access allows you to store, retreive, analyze, and print information. T or F

True

The >= rational operator selects records that are greater than or equal to the value in the condition. T or F

True

The description property is an optional field property that helps users understand what data to enter in a field. T or F

True

The table or query on which a form is based is called a record source. T or F

True

To draw a straight line in a report press and hold down shift while you draw the line. T or F

True

When you add fields to a form in layout view, the fields are added to a control layout. T or F

True

When you sort a field that contains text values in ascending order, data is arranged from A to Z. T or F

True

When you use the blank database template to create a new database, Access opens a table named Table 1 for you. T or F

True

When you use the report wizard to create a report you can base it on one or more tables. T or F

True

What is the difference between a bound control and an unbound control?

Unbound control is not connected to a record source and is used to display info, lines, rectangles, and pictures. Bound control is connected and used to display, enter and update data.

How do you change a fields data type in datasheet view?

With the field selected, click the "data type" arrow in the formatting group in the field tab. I the list, click the desired data type.

Which database object allows you to search for and retrieve data?

A query.

What information might you include on the report header section of a report?

A report title, controls that displays lines or patterns for visual interest

What does the Paste Append command do?

Adds a record (that you previously cut or copied to the clipboard) as a new row at the bottom of the data sheet.

The find and replace dialog box offers three options to help you match data in a form when searching the database. What are those three options and what do they do?

Any part of field- matches a field value that contains the find what value anywhere in the field Start of field- matches a field value that starts with the find what value Whole field- matches a field value that matches the find what value exactly

The ______data type adds a unique numeric field value to each record in a table.

Auto number

How do you create a new field In a table in datasheet view?

Click "click to add field" selector, select a data type in the list, type the field name, and then press tab it enter

What steps do you follow to use Filter By Form in a datasheet?

Click advanced button in the sort and filter group on the home tab. Click filter by form. Click arrow in the field you want to filter, click a value in the list. Click toggle filter button in the sort and filter group on the home tab.

To create a relation ship between two tables, you must design the tables so they contain a _______ field.

Common

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

Compacting

When you add a field to a form in layout view, the fields label and text box are added to the form in an object called a ______

Control

Which button in the controls group on the design tab do you use to add a picture to a report?

Insert image button

What is the Field Size property?

It sets the number of characters you can store in text, number, or AutoNumber field.

What is the format property?

It specifies how access displays numbers, dates, times, an text.

The_____create a report that you can use to print standard or custom labels.

Label wizard

When a form is displayed in ______ view, you can view the controls in the form and data form the record source at the same time.

Layout

Why should you preview an object before printing it?

Lets you see how the object will be printed so you can change the print settings before actually printing.