Mgmt Exam 2 Access - McDermont

56 terms by aliviavicari

Create a new folder

Advertisement Upgrade to remove ads

To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.

Yes

One way to create a table, is to click ____ on the Ribbon and then click the Table button.

Create

To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.

Create

The question mark (?) wildcard represents any collection of characters.

False

A field whose data type is ____ can contain any characters.

Text

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

>

In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.

Database

A(n) ___ combines both a datasheet and a form.

Split Form

In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

True

Only the fields that appear in the design grid are included in the results of the query.

True

The Monetary data type is used for fields that contain only monetary data.

False

To open a table in Design view, right-click the table in the Navigation pane and then click ____ on the shortcut menu

Design View

If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.

Format

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.

square brackets [ ]

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

True

To create a crosstab, click the ____ button on the Create tab.

Query Wizard

To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.

True

To add a new record using Form view, click the Add Record button on the Navigation bar.

False

You can click either the View button or the ____ button on the Ribbon to execute a query.

Run

A DataForm combines both a datasheet and a form.

False

To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.

Delete Column

To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.

AVG

You only can delete a primary key in ____ view.

Design

You can include ____ in calculations to indicate which calculation should be done first.

()

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

Autonumber

To change the design of a query, right-click the query and then click ____ on the shortcut menu.

Design View

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

ID

A unique identifier also is called a primary key.

True

To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.

Undo

To find all clients whose amount paid is greater than $20,000.00 and whose recruiter is recruiter 21, enter each criterion on the same line.

True

In Access, the columns in a table are called records.

False

Backing up the database as well as compacting and repairing a database are database maintenance tasks.

True

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.

True

To use the Simply Query wizard to create a query, click the ____ tab on the Ribbon and then click the Query Wizard button.

Create

The asterisk (*) wildcard represents any collection of characters.

True

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted and then press the DELETE key.

Design

To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.

Colon :

To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.

Group By

Validation rules are rules that a user must follow when entering the data.

True

To create a new database, use either the Blank Database option or a template.

True

Form view displays a single record at a time.

True

To find all clients whose amount paid is greater than $20,000.00 or whose recruiter is recruiter 21, enter each criterion on the same line.

False

A field that can be computed from other fields is called a calculated field.

True

To include totals and other statistics at the bottom of a datasheet, click the ____ button on the Home tab to include the Total row in the datasheet.

Totals

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

False

The expression for a calculated field can be typed directly into the Field row.

True

A(n) ____ contains information about a given person, product, or event.

Record

To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

False

To remove a total row that appears in a datasheet, click the ____ button on the Home tab.

Totals

To find all clients whose names begin with Be, enter Be? in the Criteria row of the design grid.

False

You create a parameter by enclosing a value in a criterion in curly braces ({}).

False

In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.

Primary Key

To include the Total row in the design grid, click the _____ button on the Design tab.

Totals

To insert a field as the last field in a table, right-click the Add New Field column heading, click ____ on the shortcut menu, type the desired field name, click the down arrow, and then ensure the correct data type is already selected.

Rename Column

To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.

T?m

A secondary key is a field in one table whose values are required to match the primary key of another table.

False

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set