Name:     ID: 
 
Email: 

COSC 4325  Chap 6

True/False
Indicate whether the statement is true or false.
 

 1. 
The effects are different when a macro is run from a switchboard versus when a macro is run from the Navigation Pane.
 

 2. 
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.
 

 3. 
If Access encounters an error in a macro, an error message displays and the Macro window automatically opens.
 

 4. 
It is not possible to group multiple macros into a single macro group.
 

 5. 
A switchboard is a special type of macro object.
 

 6. 
To create a switchboard, click the Create Switchboard button on the Database Tools tab.
 

 7. 
Access creates the Main Switchboard page automatically.
 

 8. 
It is not possible to have the switchboard display automatically when the database is opened.
 

 9. 
You modify a switchboard system using different techniques from the techniques used to create the switchboard.
 

 10. 
When you create a table in Datasheet view, Access automatically creates an ID field with the AutoNumber data type as the primary key field.
 

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

 12. 
You must create a query to view fields in PivotTable view.
 

 13. 
To create a PivotTable, you place fields in predefined areas of the table called drop zones.
 

 14. 
To hide or show data in a PivotTable, click appropriate plus (+) or minus (-) signs.
 

 15. 
To use a PivotTable based on a query, you first must open the query.
 

 16. 
You cannot create a PivotChart from scratch.
 

 17. 
There is only one chart type available for PivotCharts.
 

 18. 
Titles cannot be assigned to an axis in a PivotChart.
 

 19. 
To give a chart a cleaner look, remove the drop zones from the PivotChart.
 

 20. 
To use a PivotChart based on a query, you first must open the query.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 21. 
PivotTables and PivotCharts are normally associated with _____.
a.
Microsoft Word
c.
Microsoft InfoPath
b.
Microsoft PowerPoint
d.
Microsoft Excel
 

 22. 
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.
a.
Debug
c.
Single Step
b.
One Step
d.
Step By Step
 

 23. 
If you want to execute the next step in a macro, click the _____ button in the Macro Single Step dialog box.
a.
Next
c.
Step
b.
Single
d.
Run
 

 24. 
To run a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu.
a.
Execute
c.
Activate
b.
Perform
d.
Run
 

 25. 
To modify a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu.
a.
Design View
c.
Macro View
b.
Modify Macro
d.
Change View
 

 26. 
To run a macro in Design view, click the _____ button on the Design tab.
a.
Execute
c.
Run
b.
Perform
d.
Do
 
 
nar001-1.jpg

Figure  6-1
 

 27. 
The accompanying figure shows the switchboard for JSP Recruiters. To create a switchboard, click the Switchboard Manager button on the _____ tab.
a.
Home
c.
Design
b.
Database Tools
d.
Create
 

 28. 
The accompanying figure shows the switchboard for JSP Recruiters. The _____ command assigned to a button on a switchboard will display another switchboard page when clicked.
a.
Next Page
c.
Display Switchboard
b.
Go to Switchboard
d.
Open Page
 

 29. 
The accompanying figure shows the switchboard for JSP Recruiters. To assign a macro to a button on a switchboard page, use the _____ command.
a.
Run Macro
c.
Execute Macro
b.
Assign Macro
d.
Do Macro
 

 30. 
The accompanying figure shows the switchboard for JSP Recruiters. When Access creates a switchboard, it also creates a table called _____ to keep track of various switchboard pages and items.
a.
Macro Items
c.
Switchboard Items
b.
Page Items
d.
Application Items
 

 31. 
To import a text file, click the _____ button on the External Data tab.
a.
ASCII File
c.
Text File
b.
Text Only
d.
Other
 

 32. 
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.
a.
one-to-one
c.
many-to-one
b.
one-to-many
d.
many-to-many
 

 33. 
To relate tables, click the _____ button on the Database Tools tab.
a.
Relate Tables
c.
Referential Integrity
b.
Relationships
d.
Show Tables
 

 34. 
To create a PivotTable form, select the table or query for the form in the Navigation Pane, and click _____ on the Create tab.
a.
PivotTable
c.
Dynamic Forms
b.
Crosstab Form
d.
More Forms
 

 35. 
To create a PivotTable from a query, open the query, click the _____ button arrow and then click PivotTable View.
a.
Field List
c.
Table
b.
View
d.
Open
 

 36. 
If the PivotTable Field List does not appear, click the _____ button on the PivotTable tab to display the field list.
a.
Add Fields
c.
View Fields
b.
Field List
d.
List
 

 37. 
To open a query, right-click the query in the Navigation Pane and click _____ on the shortcut menu.
a.
Datasheet view
c.
Run
b.
Open
d.
Query View
 

 38. 
Data from fields in the _____ PivotChart drop zone will appear as related groups of data.
a.
Row
c.
Column
b.
Category
d.
Filter
 

 39. 
To create a PivotChart based on a query, open the query, click the _____ button arrow, and then click PivotChart View.
a.
View
c.
Table
b.
Open
d.
Field List
 

 40. 
To add a title to a PivotChart, click the _____ button in the property sheet for the chart.
a.
Chart Header
c.
Chart Title
b.
Add Title
d.
Header
 

Completion
Complete each statement.
 

 41. 
A(n) ____________________ is a form that includes buttons to perform a variety of actions.
 

 

 42. 
____________________ are collections of actions designed to carry out specific tasks.
 

 

 43. 
The various steps in a macro are called ____________________.
 

 

 44. 
If you have several macros, you can create a separate file for each one or you can create a single file, called a(n) ___________________, and place the macros in it.
 

 

 45. 
Individual switchboards within a switchboard system are called switchboard ___________________.
 

 

 46. 
To relate tables, click the_____________________ button on the Database Tools tab.
 

 

 47. 
To relate tables to each other in the Relationships window, first add the appropriate tables to the window. To add a table to the Relationships window, click the ____________________ button on the Design tab.
 

 

 48. 
Data can be viewed in ____________________ view, Form view, PivotTable view, and PivotChart view.
 

 

 49. 
To create a PivotTable view of a query, click the ___________________ button arrow and click PivotTable View.
 

 

 50. 
To remove drop zones from a PivotChart to give the chart a cleaner look, click the ____________________ button on the Design tab.
 

 



 
         Start Over