How can we help?

You can also find more resources in our Help Center.

50 terms

Advance Database Final Multiple Choice

STUDY
PLAY
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.