Shared Flashcard Set

Details

Access 2 Chapters 4-6
Access 2 Chapters 4-6
129
Software
04/19/2011

Additional Software Flashcards

 


 

Cards

Term

 

True

Definition

 

Grouping means creating separate collections of records sharing some common characteristic.

Term
True
Definition
A form is the appropriate choice if it is necessary to print data.
Term
True
Definition
A basic report is a report that lists all the fields and all the records in a table without any special features.
Term
False
Definition
When you view a report in Print Preview, you can make changes to the report
Term
False
Definition
A hyperlink field can contain only links to Web pages.
Term
True
Definition
You can use the OLE Object data type or the Attachment data type to store a picture.
Term
True
Definition
In Datasheet view, an Attachment field appears as a paper clip rather than the field name.
Term
True
Definition
When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.
Term
False
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
False
Definition
Rows in a datasheet may be different sizes.
Term
True
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
False
Definition
Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.
Term
False
Definition
Any row and column spacing changes made to a datasheet are saved automatically when you close the table.
Term
True
Definition
When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.
Term
False
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
True
Definition
You can use the ruler to select multiple controls.
Term
False
Definition
If the field list covers a portion of the form, you can move it but you cannot resize it.
Term
False
Definition
When you add a title to a form using the Title button, Access places the title in the Detail section.
Term
True
Definition
When a form includes a subform, the subform is a separate object in the database.
Term
False
Definition
Access only allows you to change the font and font size for a label on a form.
Term
False
Definition
You cannot change the size of the property sheet.
Term
False
Definition
Once the tab order for fields is determined, it cannot be changed.
Term
True
Definition
A form that contains a subform includes navigation buttons for both the form and subform.
Term
False
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
True
Definition
An input mask specifies how data is to be entered and how it will appear.
Term
True
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
False
Definition
To align controls, use the appropriate alignment buttons on the Design tab.
Term
False
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
False
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
Memo
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
Options
Definition
If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.
Term
Design View
Definition
To modify the design of a table, right-click the table in the Navigation Pane, and click _____ on the shortcut menu.
Term
Build
Definition
To use the Input Mask Wizard, select the Input Mask property and then select the _____ button.
Term
Bitmap Image Object
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
Manage Attachments
Definition
To insert data into an Attachment field, use the _____ on the Attachment’s field’s shortcut menu.
Term
Insert Object
Definition
If the entries in an OLE field display Pbrush rather than Bitmap images, right-click the OLE field, and click _____.
Term
Edit Hyperlink
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
Standard Height
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
Standard Width
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
Open
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
Manage Attachments
Definition
To view attachments in a field, right-click the field, and then click _____ on the shortcut menu.
Term
subform
Definition
A form that is contained with another form is called a(n) _____.
Term
Form Design
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
Add Existing Fields
Definition
To display a field list, click the ____ button on the Design tab.
Term
Quick Access Toolbar
Definition
To save a form and assign it a name, click the Save button on the _____.
Term
Arrange
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
Fill/Back Color
Definition
To change the background color of a form, you can use the _____ button on the Design tab.
Term
Fill/Back Color
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
Title
Definition
To add a title to a form, click the _____ button on the Design tab.
Term
Arrange
Definition
To add a Form Header section to a form, click the Form Header/Footer button on the _____ tab.
Term
Design
Definition
To place a subform on a form, use the Subform/Subreport tool on the _____ tab.
Term
Open
Definition
To resize columns in a subform, right-click the subform in the Navigation Pane, and click ____ on the shortcut menu.
Term
View
Definition
To switch from Design view to Form view to display the form, click the _____ button.
Term
Size Mode
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
Font Color
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
Property Sheet
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
Property Sheet
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
Arrange
Definition
To change the tab order in which fields are encountered on a form, click the Tab Order button on the _____ tab.
Term
Open
Definition
To use a form to view data, right-click the form in the Navigation Pane, and then click _____ on the shortcut menu.
Term
Manage Attachments
Definition
To display an attachment, right-click the Attachments field, and click the _____ command on the shortcut menu.
Term
Database Tools
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
Form
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
Blank Form
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
*Healthcare Management*
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
True
Definition
A PivotTable differs from a crosstab because a PivotTable is dynamic.
Term
False
Definition
The effects are different when a macro is run from a switchboard versus when a macro is run from the Navigation Pane.
Term
False
Definition
The first column in the Macro window is the Comment column.
Term
True
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
False
Definition
If Access encounters an error in a macro, an error message displays and the Macro window automatically opens.
Term
False
Definition
It is not possible to group multiple macros into a single macro group.
Term
True
Definition
By default, Access disables macros when it opens a database and displays a Security Warning.
Term
False
Definition
A switchboard is a special type of macro object.
Term
False
Definition
To create a switchboard, click the Create Switchboard button on the Database Tools tab.
Term
True
Definition
Access creates the Main Switchboard page automatically.
Term
False
Definition
It is not possible to have the switchboard display automatically when the database is opened.
Term
False
Definition
You modify a switchboard system using different techniques from the techniques used to create the switchboard.
Term
True
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
True
Definition
You can create new tables in either Datasheet view or Design view.
Term
True
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
False
Definition
You must create a query to view fields in PivotTable view.
Term
True
Definition
To create a PivotTable, you place fields in predefined areas of the table called drop zones.
Term
True
Definition
To hide or show data in a PivotTable, click appropriate plus (+) or minus (-) signs.
Term
True
Definition
To use a PivotTable based on a query, you first must open the query.
Term
False
Definition
You cannot create a PivotChart from scratch.
Term
True
Definition
Fields can be removed from drop zones by clicking the field name and then pressing the DELETE key.
Term
False
Definition
There is only one chart type available for PivotCharts.
Term
False
Definition
Titles cannot be assigned to an axis in a PivotChart.
Term
True
Definition
To give a chart a cleaner look, remove the drop zones from the PivotChart.
Term
True
Definition
To use a PivotChart based on a query, you first must open the query.
Term
True
Definition
Macros are collections of actions designed to carry out specific tasks.
Term
False
Definition
Many macro actions require additional information, called the parameters of the action.
Term
False
Definition
Individual switchboards within a switchboard system are called switchboard tabs.
Term
True
Definition
When Access creates a switchboard, it also creates a table called Switchboard Items.
Term
False
Definition
PivotTables and PivotCharts can be used to analyze past data and predict future patterns and trends, a technique knows as data detection.
Term
Microsoft Excel
Definition
PivotTables and PivotCharts are normally associated with _____.
Term
Macro
Definition
To begin creating a macro, click the _____ button arrow on the Create tab.
Term
F1
Definition
To find detailed information on the purpose of a macro action, select the action and press the _____ key(s).
Term
Single Step
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
Stop All Macros
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
Step
Definition
If you want to execute the next step in a macro, click the _____ button in the Macro Single Step dialog box.
Term
Run
Definition
To run a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu.
Term
INSERT
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
Design View
Definition
To modify a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu.
Term
Run
Definition
To run a macro in Design view, click the _____ button on the Design tab.
Term
Trust Center
Definition
To make adjustments to Access security settings, click the Access Options button on the Office Button menu and then click _____.
Term
Switchboard Manager
Definition
To modify the switchboard system after it has been created, click the _____ button on the Database Tools tab.
Term
Home
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
Options
Definition
If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.
Term
Table Design
Definition
To create a table in Design view, click the _____ button on the Create tab.
Term
Text File
Definition
To import a text file, click the _____ button on the External Data tab.
Term
many-to-many
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
Relationships
Definition
To relate tables, click the _____ button on the Database Tools tab.
Term
More Forms
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
Filter
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
View
Definition
To create a PivotTable from a query, open the query, click the _____ button arrow and then click PivotTable View.
Term
Captions
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
Field List
Definition
If the PivotTable Field List does not appear, click the _____ button on the PivotTable tab to display the field list.
Term
Open
Definition
To open a query, right-click the query in the Navigation Pane and click _____ on the shortcut menu.
Term
Add
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
Filter
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
Category
Definition
Data from fields in the _____ PivotChart drop zone will appear as related groups of data.
Term
Data
Definition
Data from fields in the _____ PivotChart drop zone will be summarized within the chart.
Term
DELETE
Definition
To remove fields from drop zones, click the field name and then press the _____ key(s).
Term
View
Definition
To create a PivotChart based on a query, open the query, click the _____ button arrow, and then click PivotChart View.
Term
Comment
Action
Arguments
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
Data
Category
Filter
Series
Definition
The drop zones available in PivotChart view are _____.