Advance Database Final Multiple Choice

50 terms by Brysonbab

Create a new folder

Advertisement Upgrade to remove ads

Memo

The _____ data type is used for a field that contains text that is variable in length and that can potentially be very lengthy.

Design View

To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut menu.

Build

To use the Input Mask Wizard, select the Input Mask property in the field's property sheet and then select the _____ button.

Record selector

In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the _____ to the desired size.

Row Height

In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, right-click the record selector, and click _____ to change the row spacing

Standard Height

To undo changes to the row height, right-click the row selector, click Row Height on the shortcut menu, and then click the _____ check box in the Row Height dialog box

Create From File

To enter a picture stored on a USB drive into an OLE field, right-click the OLE field, click Insert Object and then click the _____ option button.

Bitmap Image Object

To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

Manage Attachments

To insert data into an Attachment field, use the _____ command on the Attachment's field's shortcut menu.

Manage Attachments

To view attachments in a field, right-click the field, and then click _____ on the shortcut menu

Subform

A form that is contained within another form is called a(n) _____.

Form Design

To create a form in Design view, select the table for the form, click Create on the Ribbon, and then click _____ on the Create tab.

Add Existing Field

To display a field list in Design view, click the ____ button on the Design tab.

Quick Access Toolbar

To save a form and assign it a name, click the Save button on the _____.

Arrange

To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment button on the _____ tab.

Fill/Back Color

To change the background color of a form, you can use the _____ button on the Design tab.

Fill/Back Color

To use the shortcut menu to change the background color of a form, right-click the form and select the _____ command on the shortcut menu.

Title

To add a title to a form, click the _____ button on the Design tab.

Design

To place a subform on a form, use the Subform/Subreport tool on the _____ tab.

View

To switch from Design view to Form view to display the form, click the _____ button.

Property Sheet

To change the Tab Stop property for a control, select the control, click the _____ button on the Design tab, and change the value of the Tab Stop property from Yes to No.

Open

To use a form to view data, right-click the form in the Navigation Pane, and then click _____ on the shortcut menu.

Database Tools

To view object dependencies, click the object of interest in the Navigation Pane, click the _____ tab on the Ribbon, and then click the Object Dependencies button.

Information

The condition, _____, entered in the Criteria row of a memo field in a query window would retrieve all records where the memo field had any mention of Information.

Date()

To test for the current date in a query, type _____ in the Criteria row of the appropriate column.

Form

To create a simple form with a datasheet, select the table that is the "one" part of a one-to-many relationship in the Navigation Pane, click Create on the Ribbon, and then click the ____ button on the Create tab.

Blank Form

To create a multitable form based on the "many" table, click the _____ button on the Create tab to create a form in Layout view.

Many-to-many

If the primary key of the Course Offerings table contains the primary key for both the Client table and Course table, there is a _____ relationship between clients and seminars.

Property Sheet

In the accompanying figure, an expression will be entered in the Expression Builder dialog box. To enter a caption for this expression, click the _____ button to display the property sheet.

Report Design

To create a report from scratch, click the Create tab, and then click the _____ button.

Group & Sort

To display the Group, Sort, and Total pane, click the _____ button on the Design tab.

Group Header

The contents of the _____ section are printed before the records in a particular group.

Add Existing Field

To add fields to a report, click the _____ button on the Design tab to add a field list.

Print Preview

To periodically view a report to gauge how it will look containing data, click _____ on the View menu.

Undo

To reverse the most recent change to a report, click the _____ button on the Quick Access Toolbar.

Use Control Wizards

The SubReport Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subreport, make sure the _____ button is selected.

Design View

The SubReport Wizard displays in the accompanying figure. To open a subreport in Design view, right-click the subreport in the Navigation Pane and click _____ on the shortcut menu.

Delete

To delete a control from a report, click the control and then press the _____ key(s).

Shift+Enter

To extend a heading over two lines, click in the appropriate position to produce an insertion point and then press the _____ key(s).

Can Grow

To spread data over two lines, change the value of the _____ property.

Can Shrink

To remove blank lines that occur when a field is empty, change the value of the _____ property.

Repeat Section

To cause the contents of the Group Header section to appear at the top of each page, change the value of the _____ property.

Title

To add a title to a report, click the _____ button on the Design tab.

Date and Time

To add a date to a report, click the _____ button on the Design tab.

Sum

To calculate the total of a field, such as Amount Paid, use the _____ aggregate function.

Format

To ensure that a calculated control displays as currency, change the _____ property.

Report Header/Footer

To display a Report Footer section, right-click any open area of the report and click _____ on the shortcut menu.

If

To assign a conditional value, use the _____ function.

Text Box

To add a text box to a report, click the _____ tool in the Tools group on the Design tab.

Page Setup

To change the report margins, click the Margins button on the _____ 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