Advance Database True/False

40 terms by Brysonbab 

Create a new folder

Advertisement Upgrade to remove ads

True

In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

False

A hyperlink field can contain only links to Web pages.

True

When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

False

When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field.

False

Rows in a datasheet may be different sizes.

True

When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

False

Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

False

Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

False

To select more than one control at a time on a form, press and hold down the ALT key as you select additional controls.

True

You can use the ruler to select multiple controls.

True

When a form includes a subform, the subform is a separate object in the database.

False

In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. The Stretch size mode is the best option for photographs.

True

In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned correctly.

True

In the accompanying figure, the portion of the picture that appears as well as the way it appears is determined by the size mode. To change the size mode, use the property sheet.

False

Access only allows you to change the font and font size for a label on a form.

False

You cannot change the size of the property sheet.

False

Once the tab order for fields is determined, it cannot be changed.

True

A form that contains a subform includes navigation buttons for both the form and subform.

True

You can create new Access tables in either Datasheet view or Design view.

False

If you link an Excel workbook to an Access database, you can edit the linked table in Access.

False

When you create a report in Design view, the initial report that displays in the Design window contains all the fields in the underlying table or query.

True

To create a new query, click the Query Design button on the Create tab.

False

To display the Expression Builder dialog box, click the Build Expression button on the Design tab.

True

The record source for a report is the table or query that will furnish the data for the report.

False

You can move a property sheet box but you cannot resize it.

False

A report contains three types of controls: bound controls, unbound controls, and formatted controls.

True

The process of converting an unbound control to a bound control is called binding.

False

To concatenate strings, you use the asterisk (*) operator.

True

The process of combining two or more text data items into a single expression is called concatenation.

True

To ungroup controls, use the Ungroup button on the Size/Space button menu on the Arrange tab.

True

The subreport appears as a separate report in the Navigation Pane.

False

If the Can Shrink property is set to No, Access will remove blank lines that occur when the field is empty.

True

To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

False

To add a page number to a report, use the Report Footer button.

True

When you use the Title button to add a title to a report, the title is the same as the name of the report object.

True

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

False

To display the Group, Sort, and Total pane, click the Group Report button.

False

To find the largest value, use the LARGE aggregate function.

True

To add totals or other statistics to a footer, add a text box control.

True

To change the report margins, use the Margins button on the Page Setup tab.

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