Term
|
Definition
Grouping means creating separate collections of records sharing some common characteristic. |
|
|
Term
|
Definition
A form is the appropriate choice if it is necessary to print data. |
|
|
Term
|
Definition
A basic report is a report that lists all the fields and all the records in a table without any special features. |
|
|
Term
|
Definition
When you view a report in Print Preview, you can make changes to the report |
|
|
Term
|
Definition
A hyperlink field can contain only links to Web pages. |
|
|
Term
|
Definition
You can use the OLE Object data type or the Attachment data type to store a picture. |
|
|
Term
|
Definition
In Datasheet view, an Attachment field appears as a paper clip rather than the field name. |
|
|
Term
|
Definition
When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions. |
|
|
Term
|
Definition
When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field. |
|
|
Term
|
Definition
Rows in a datasheet may be different sizes. |
|
|
Term
|
Definition
When you insert data in an OLE field, you either can create a new object or insert an already created object in the field. |
|
|
Term
|
Definition
Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access. |
|
|
Term
|
Definition
Any row and column spacing changes made to a datasheet are saved automatically when you close the table. |
|
|
Term
|
Definition
When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture. |
|
|
Term
|
Definition
To select more than one control at a time on a form, press and hold down the ALT key as you select additional controls. |
|
|
Term
|
Definition
You can use the ruler to select multiple controls. |
|
|
Term
|
Definition
If the field list covers a portion of the form, you can move it but you cannot resize it. |
|
|
Term
|
Definition
When you add a title to a form using the Title button, Access places the title in the Detail section. |
|
|
Term
|
Definition
When a form includes a subform, the subform is a separate object in the database. |
|
|
Term
|
Definition
Access only allows you to change the font and font size for a label on a form. |
|
|
Term
|
Definition
You cannot change the size of the property sheet. |
|
|
Term
|
Definition
Once the tab order for fields is determined, it cannot be changed. |
|
|
Term
|
Definition
A form that contains a subform includes navigation buttons for both the form and subform. |
|
|
Term
|
Definition
To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys. |
|
|
Term
|
Definition
An input mask specifies how data is to be entered and how it will appear. |
|
|
Term
|
Definition
To change the size of a row, you use a record’s record selector, which is the small box at the beginning of each record. |
|
|
Term
|
Definition
To align controls, use the appropriate alignment buttons on the Design tab. |
|
|
Term
|
Definition
Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed. |
|
|
Term
|
Definition
If you create a form with the Form button for a table that is the “one” table in a one-to-many relationship, Access automatically includes the “many” table in a subform. |
|
|
Term
|
Definition
The _____ data type is used for a field that contains text that is variable in length and that can potentially be very lengthy. |
|
|
Term
|
Definition
If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box. |
|
|
Term
|
Definition
To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut menu. |
|
|
Term
|
Definition
To use the Input Mask Wizard, select the Input Mask property and then select the _____ button. |
|
|
Term
|
Definition
To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), right-click the field, click _____, click Convert, and then double-click Picture. |
|
|
Term
|
Definition
To insert data into an Attachment field, use the _____ on the Attachment’s field’s shortcut menu. |
|
|
Term
|
Definition
If the entries in an OLE field display Pbrush rather than Bitmap images, right-click the OLE field, and click _____. |
|
|
Term
|
Definition
To enter data into a Hyperlink field, right-click the Hyperlink field, click Hyperlink on the shortcut menu, and then click _____ on the Hyperlink submenu. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To undo changes to the column width, right-click the field selector, click Column Width on the shortcut menu, and then click the _____ check box in the Column Width dialog box. |
|
|
Term
|
Definition
To view data, such as a picture, in an OLE field, right-click the field, click Bitmap Image Object on the shortcut menu, and then click _____. |
|
|
Term
|
Definition
To view attachments in a field, right-click the field, and then click _____ on the shortcut menu. |
|
|
Term
|
Definition
A form that is contained with another form is called a(n) _____. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To display a field list, click the ____ button on the Design tab. |
|
|
Term
|
Definition
To save a form and assign it a name, click the Save button on the _____. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To change the background color of a form, you can use the _____ button on the Design tab. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To add a title to a form, click the _____ button on the Design tab. |
|
|
Term
|
Definition
To add a Form Header section to a form, click the Form Header/Footer button on the _____ tab. |
|
|
Term
|
Definition
To place a subform on a form, use the Subform/Subreport tool on the _____ tab. |
|
|
Term
|
Definition
To resize columns in a subform, right-click the subform in the Navigation Pane, and click ____ on the shortcut menu. |
|
|
Term
|
Definition
To switch from Design view to Form view to display the form, click the _____ button. |
|
|
Term
|
Definition
To change the size mode for a picture, click the control, click the Property Sheet button on the Design tab, and then click the _____ property box. |
|
|
Term
|
Definition
To change the font color of a label, select the label, and click the _____ arrow on the Design tab to display a color palette. |
|
|
Term
|
Definition
To change the special effect of a label, select the label, click the _____ button on the Design tab, and then click the Special Effect property box arrow. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To change the tab order in which fields are encountered on a form, click the Tab Order button on the _____ tab. |
|
|
Term
|
Definition
To use a form to view data, right-click the form in the Navigation Pane, and then click _____ on the shortcut menu. |
|
|
Term
|
Definition
To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
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. |
|
|
Term
|
Definition
To create a form with a datasheet in Layout view, click the _____ button on the Create tab to create a form in Layout view. |
|
|
Term
|
Definition
The condition, _____, entered in the Criteria row of a memo field on a query window would retrieve all records where the memo field had any mention of Healthcare Management. |
|
|
Term
|
Definition
A PivotTable differs from a crosstab because a PivotTable is dynamic. |
|
|
Term
|
Definition
The effects are different when a macro is run from a switchboard versus when a macro is run from the Navigation Pane. |
|
|
Term
|
Definition
The first column in the Macro window is the Comment column. |
|
|
Term
|
Definition
If you have problems with a macro, you can single-step the macro, that is, proceed through the macro a step at a time in Design view. |
|
|
Term
|
Definition
If Access encounters an error in a macro, an error message displays and the Macro window automatically opens. |
|
|
Term
|
Definition
It is not possible to group multiple macros into a single macro group. |
|
|
Term
|
Definition
By default, Access disables macros when it opens a database and displays a Security Warning. |
|
|
Term
|
Definition
A switchboard is a special type of macro object. |
|
|
Term
|
Definition
To create a switchboard, click the Create Switchboard button on the Database Tools tab. |
|
|
Term
|
Definition
Access creates the Main Switchboard page automatically. |
|
|
Term
|
Definition
It is not possible to have the switchboard display automatically when the database is opened. |
|
|
Term
|
Definition
You modify a switchboard system using different techniques from the techniques used to create the switchboard. |
|
|
Term
|
Definition
When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field. |
|
|
Term
|
Definition
You can create new tables in either Datasheet view or Design view. |
|
|
Term
|
Definition
In a PivotTable, you can show different levels of detail easily as well as change the organization or layout of the table by dragging items. |
|
|
Term
|
Definition
You must create a query to view fields in PivotTable view. |
|
|
Term
|
Definition
To create a PivotTable, you place fields in predefined areas of the table called drop zones. |
|
|
Term
|
Definition
To hide or show data in a PivotTable, click appropriate plus (+) or minus (-) signs. |
|
|
Term
|
Definition
To use a PivotTable based on a query, you first must open the query. |
|
|
Term
|
Definition
You cannot create a PivotChart from scratch. |
|
|
Term
|
Definition
Fields can be removed from drop zones by clicking the field name and then pressing the DELETE key. |
|
|
Term
|
Definition
There is only one chart type available for PivotCharts. |
|
|
Term
|
Definition
Titles cannot be assigned to an axis in a PivotChart. |
|
|
Term
|
Definition
To give a chart a cleaner look, remove the drop zones from the PivotChart. |
|
|
Term
|
Definition
To use a PivotChart based on a query, you first must open the query. |
|
|
Term
|
Definition
Macros are collections of actions designed to carry out specific tasks. |
|
|
Term
|
Definition
Many macro actions require additional information, called the parameters of the action. |
|
|
Term
|
Definition
Individual switchboards within a switchboard system are called switchboard tabs. |
|
|
Term
|
Definition
When Access creates a switchboard, it also creates a table called Switchboard Items. |
|
|
Term
|
Definition
PivotTables and PivotCharts can be used to analyze past data and predict future patterns and trends, a technique knows as data detection. |
|
|
Term
|
Definition
PivotTables and PivotCharts are normally associated with _____. |
|
|
Term
|
Definition
To begin creating a macro, click the _____ button arrow on the Create tab. |
|
|
Term
|
Definition
To find detailed information on the purpose of a macro action, select the action and press the _____ key(s). |
|
|
Term
|
Definition
To proceed through a macro one step at a time, open the macro in Design view, and then click the _____ button on the Design tab. |
|
|
Term
|
Definition
If you want to terminate the process of executing a macro one step at a time, click the _____ button in the Macro Single Step dialog box. |
|
|
Term
|
Definition
If you want to execute the next step in a macro, click the _____ button in the Macro Single Step dialog box. |
|
|
Term
|
Definition
To run a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu. |
|
|
Term
|
Definition
To insert a new action in a macro, click the row selector for the row beneath where you want to insert the action and press the _____ key(s). |
|
|
Term
|
Definition
To modify a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu. |
|
|
Term
|
Definition
To run a macro in Design view, click the _____ button on the Design tab. |
|
|
Term
|
Definition
To make adjustments to Access security settings, click the Access Options button on the Office Button menu and then click _____. |
|
|
Term
|
Definition
To modify the switchboard system after it has been created, click the _____ button on the Database Tools tab. |
|
|
Term
|
Definition
To copy the structure of an existing table, select the table in the Navigation Pane, click Copy on the _____ tab, and then click Paste. |
|
|
Term
|
Definition
If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box. |
|
|
Term
|
Definition
To create a table in Design view, click the _____ button on the Create tab. |
|
|
Term
|
Definition
To import a text file, click the _____ button on the External Data tab. |
|
|
Term
|
Definition
If the primary key of the Seminar Offerings table contains the primary key for both the Client table and Seminar table, there is a _____ relationship between clients and seminars. |
|
|
Term
|
Definition
To relate tables, click the _____ button on the Database Tools tab. |
|
|
Term
|
Definition
To create a PivotTable form, select the table or query for the form in the Navigation Pane, and click _____ on the Create tab. |
|
|
Term
|
Definition
Data from fields in the _____ PivotTable drop zone will not appear in the table but can be used to restrict the data that appears. |
|
|
Term
|
Definition
To create a PivotTable from a query, open the query, click the _____ button arrow and then click PivotTable View. |
|
|
Term
|
Definition
To change the heading for a column in a PivotTable, right-click the column heading, click the Property Sheet button on the Design tab, and then click the _____ tab on the property sheet. |
|
|
Term
|
Definition
If the PivotTable Field List does not appear, click the _____ button on the PivotTable tab to display the field list. |
|
|
Term
|
Definition
To open a query, right-click the query in the Navigation Pane and click _____ on the shortcut menu. |
|
|
Term
|
Definition
To add a field to the filter area of a PivotTable, click the field in the PivotTable Field List, click Filter Area from the list of available areas, and then click the _____ button. |
|
|
Term
|
Definition
Data from fields in the _____ PivotChart drop zone will not appear in the chart but can be used to restrict the data that appears. |
|
|
Term
|
Definition
Data from fields in the _____ PivotChart drop zone will appear as related groups of data. |
|
|
Term
|
Definition
Data from fields in the _____ PivotChart drop zone will be summarized within the chart. |
|
|
Term
|
Definition
To remove fields from drop zones, click the field name and then press the _____ key(s). |
|
|
Term
|
Definition
To create a PivotChart based on a query, open the query, click the _____ button arrow, and then click PivotChart View. |
|
|
Term
|
Definition
The Macro Builder window includes the _____ columns. |
|
|
Term
closes the database closes the switchboard returns you to the Getting Started with Microsoft Access screen |
|
Definition
The Exit Application command _____. |
|
|
Term
Design view Datasheet view |
|
Definition
You can create tables in _____. |
|
|
Term
Datasheet view PivotTable view Form view PivotChart view |
|
Definition
You can view data in _____. |
|
|
Term
|
Definition
The drop zones available in PivotChart view are _____. |
|
|