[CIT350] Database Adminstration Exam #1 (Part One)

Which keystroke combination moves focus to the last field of the last record?

[Ctrl][End]

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Record

Values in an AutoNumber field are automatically created by Access.

True

Which Access object contains all of the raw data within the database?

Table

Access databases cannot be password protected.​

False

Which editing keystroke deletes one character to the right of the insertion point?

[Delete]

Microsoft Access 2016 can best be described as ____ software.

Database

Pressing [Ctrl][;] will insert the current date in a Date field.

True

Which is NOT true about Access?

Reporting is limited to 20 saved reports.

Which data type stores Web addresses?

Hyperlink

In Access, data entry screens are called forms.

True

Which data type links files created in other programs such as pictures or documents?

Attachment

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

AutoNumber

Which is NOT a feature of Access reports?

easy-to-use data entry screen

Press [Esc] once to undo a change to the current field.

True

No two records can have the same value in the primary key field.

True

Which of the following is NOT a data type?

Formula

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

field

A primary key field uniquely identifies each record.

True

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

False

Each object in an Access database application displays at the left side of the Access window in the ____.

Navigation Pane

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

File

Tables, queries, and forms are examples of Access ____.

Objects

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Referential

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

False

To delete a field from a query in Query Design view, click the _ for the field, and then press DELETE.

field selector

In SQL view, a select query starts with the SQL keyword _.

SELECT

To move a field in Query Design view, you drag the field by its field selector.

True

You can freeze one or more fields in a datasheet so they remain visible at all times.

True

To query for null values, use Is Null as the criterion.

False

Which of the following can you change when formatting a datasheet?

gridlines

Access adds # signs around text criteria in Date/Time fields.

False

The term _ describes a field value that does not exist because it has never been entered.

null

Query Design view presents the fields you can use for a query in small windows called field _.

lists

You click the _ button to close the Filter by Form grid.

Toggle Filter

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

False

In Query Design view, how can you add a field to the query design grid?

Double-click the field in the field list.

You can format a table datasheet by setting the alternate record color in Table Datasheet view.

False

A is a saved object within the database, whereas a is temporary.

query; filter

To apply the last filter you selected to a datasheet, you click the _ button.

Toggle Filter

How can you list the records in a query datasheet in A-Z order by CustomerName?

Click a value in the CustomerName field, and then click the Ascending button.

When you double-click a field in a field list in Query Design view, you _.

add the field to the query design grid

You can make formatting changes to a table, such as font color and font size, in Table Design view.

False

What happens when you run a query from Query Design view?

Access displays a datasheet containing the query results.

If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?

names that start with D and end with n, such as Dean

What should you do before applying a new filter to a datasheet?

Clear all previous filters.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

True

In Query Design view, the _ shows you the field names, sort orders, and criteria used with a query.

query design grid

What button do you use on the Query Tools Design tab to add a field list to a query?

Show Table button

_ is a standardized language that all major relational database software uses.

Structured Query Language (SQL)

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

False

You can insert a logo in the form header using the ____ button on the Form Design Tools tab.

Logo

In a split form, the upper half shows one record of data while the lower half lists records in a datasheet presentation.

True

A(n) _ is an image that fills the entire form, appearing "behind" the other controls.

background image

What is the advantage of grouping controls on a form?

You can apply the same changes to the controls all at once.

Use a Size option when you want to specify the exact height and width of two selected controls.

False

Which of the following is an appropriate entry for the Hyperlink Address property of a form control?

http://www.cengage.com

Which of the following form controls can you format by applying a style to it?

button

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _ button on the Form Layout Tools Arrange tab.

Tabular

Which two properties control how a form and subform are linked?

Link Child Fields and Link Master Fields

If you select a(n) _ control on a form in Form view, it means "yes" or "true".

check box

Which of the following commands aligns text in the center of a label control?

Center

What do you change when you drag the right border of a form in Form Design view?

the width of the form

Which of the following controls would you add to a form to print the current record?

command button

A check box control usually displays a "yes" or "no" answer for a field.

True

When you use the Combo Box Wizard, you can have the combo box list the values from a table or query or you can _.

enter the values for the combo box

Set the Locked property of a form control to Yes if you want to prevent users from entering data in the control.

True

To add a heading to the Detail section of a form, you use a text box control.

False

You use a toggle button on a form to _.

indicate a "yes" or "no" value

To modify the number of items displayed in a combo box, use the List Rows property.

True

The Enabled property specifies whether you can edit a control in Form view.

False

If the _ property for a form control is set to No, the control cannot have the focus in Form view.

Enabled

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

True

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

True

To add a subform to a form in Form Design view, you use the Subform/Subreport control.

True