Cit 350 Exam 1: Access

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

True

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

Which is NOT a feature of Access reports?
a. headers
b. calculations on groups of records
c. footers
d. easy-to-use data entry screen

easy-to-use data entry screen

\____ View provides the most options for defining fields.

Table design

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

True

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

True

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

True

Which of the following is NOT available to you as you start Access?
a. recalibrating an existing database
b. opening an existing database
c. creating a new blank database
d. creating a new database from a template

recalibrating an existing database

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

False

In Access, data entry screens are called forms. \_________________________

True

"Focus" refers to which data you would edit if you started typing.

True

Which data type stores only one of two values?

Yes/No

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

Navigation Pane

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

Record

Which of the following keys will help you delete unwanted data in Edit mode?

\[Back space]

Access databases cannot be password protected.​

False

In Navigation mode, press [Tab] or \____ to move to the next field within the same record.

\[Enter]

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

Referential

While editing a record, pressing [Esc] a second time \____.

removes all changes made to the record you are currently editing

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

Attachment

Which is NOT true about Access?
a. Reporting is limited to 20 saved reports.
b. It relates lists of information in a relational database.
c. It can be used to create forms
d. Multiple users can simultaneously enter and update data within Access.

Reporting is limited to 20 saved reports.

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

table

You can use the Calendar Box to enter dates in a Date/Time field. \_________________________

False

Which Access object provides an easy-to-use data entry screen?

form

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

\[Delete]

What criterion would you use in the LastName field to find records that do not contain a last name?

Is Null

Use Query Design view to display the results of a query.

False

A query is a temporary view of the data that is removed when you close the query in Query Design view.

False

You could use "Madison" as the criterion for a Yes/No field.

False

In large datasheets, you can \____ certain fields so that they remain on the screen at all times.

freeze

In the criterion 8/*/2021, the asterisk (*) is called a wildcard

True

Query for zero-length values by entering Is Null as the criterion.

False

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

False

Before you close a query datasheet, you must save your changes to the data.

False

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Find and Replace

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field

False

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

True

To replace "coffee" with "beverage" in any part of a field, you click the \_____ in the Find and Replace dialog box

Match arrow

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

gridlines

What happens when you run a query with the Is Null criterion in the Product Type field?

The results include only records with no Product Type value.

If you add Is Null as the criterion for the Advisor field in the Students table, what are the results?

Students without advisors

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

True

To filter for comparative data, use the \_____ feature.

Filter by Form

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

Modify Expression

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)

The easiest way to filter the records for an exact match is to use the \_____ feature.

Filter by Selection

How do you display the results of a query listed in the Navigation Pane?

Double-click the query

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

Clear all previous filters

What does the criterion

less than or equal to 200

If you create a blank form, you must set the \_____ property to display data on the form.

Record source

Objects you add to custom groups in the Navigation Pane are \_____.

shortcuts to the actual objects

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

button

To remove scroll bars on small forms, set the Scroll Bars property to As Needed.

False

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

True

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

True

A form \____ is the general way that the data and controls are arranged on the form.

layout

Which of the following is the most common type of bound control you can add to a form?

text box

To have form users select one of three options, add a(n) \_____ to the form.

option group

Where does a background image appear in a report?

behind the other controls

Which control works best to display three choices—1, 2, or 3—for a Rating field?

option grouping

You can convert a form label to a hyperlink using the control's Web property.

False

A(n) \_____ is a common control to place within an option group.

option button

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

Logo

What is the advantage of grouping controls on a form?

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

If you are displaying values from two fields in a combo box, you can change the \_____ property of the combo box control to display both values in the list.

Column count

A check box and a command button display "yes" or "no" answers in a field.

False

What could you use to display the amount of a 25% discount on a form?

a calculated control

You can select one or more option buttons at the same time within an option group

False

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top. This arrangement is called a(n) \_____.

tabular layout

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?

Default view

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

False

Sylvia wants to align the right edges of the labels on a form. After selecting the controls in Form Design view, what should she do?

Click the Align button on the Arrange tab and then click Right.

When you add a field with an Attachment data type to a form, it appears as a(n) Photo control.

False

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

Enabled

The \_____ New Page property helps you start printing a section at the top of a new page.

Force

You can display numbers on a report in Currency, Percent, or Standard formats.

True

To display the contents of a text box in more than one font size or color, set the \_____ property of the text box to RTF.

Text Format

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

The data is centered in the text box.

To resize a selected control in Report Design view, you can use the \_____.

horizontal resize pointer

To change the text displayed on the report tab, you set the \_____ property of the report.

caption

In Report Design view, you display a Number field value as a percentage using the \_____ property.

Format

Compared to forms and datasheets, \____ give you more control over how data is arranged when printed.

reports

You can set the Decimal Places property for fields with a Currency data type.

True

Which control do you use to add a report to another report?

subform/subreport

To format a number with a dollar sign ($) as in $50.99, use the Standard format.

False

What could you do to clarify that the TaxRate field in a report contains percentages?

Apply the Percent format to the field.

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

False

To change the text displayed on the report tab, use the report's Caption property.

True

What can you do when a report has blank pages in Print Preview?

Click the Margins button on the Print Preview tab to change the report margins

Which of the following report controls can you format in bold?

Label

Which of the following views provides the most options for creating and modifying a report?

Report design view

You can display page numbers on a report in a "Page 1 of 2" format.

True

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

All the names in the City column are centered.

To add a sort to a report in Report Design view, you use the \_____ button

Group & sort

You can use the Format property to display dates in a report using a Short Date format.

True

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

False

Phil created a report based on a query named NewClients. What report property should he use to add a calculated field to the query?

Record source property

Report Design View gives you full control of all aspects of a report.

True

How can you select all the labels in a report section when working in Report Design view?

Drag a selection box around the controls