access tutorial 1
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 1. The Save button on the Quick Access Toolbar is used to ____.
a. / save the database file to your diskb. / save the database file with a new name
c. / save the design of an Access object
d. / none of the above; this is a setting determined by the user.
____ 2. In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ in the database.
a. / first field / c. / first recordb. / current field / d. / next available row for a new record
____ 3. A database is a convenient way to ____ related data.
a. / enter / c. / maintainb. / retrieve / d. / all of the above
____ 4. Which of the following could be defined as a field in a database?
a. / customer name / c. / phone numberb. / order number / d. / all of the above
____ 5. An example of a relational DBMS is ____.
a. / Word / c. / PowerPointb. / Excel / d. / Access
____ 6. Access allows you to ask questions and obtain information about your data through use of a built-in ____.
a. / inquisitor / c. / table generatorb. / query language / d. / report generator
____ 7. The navigation buttons allow you to ____.
a. / delete records / c. / move to the next record in the tableb. / relocate records / d. / all of the above
____ 8. Access can guide you through the steps to create a query by using the Query ____.
a. / Generator / c. / Creatorb. / Wizard / d. / Manager
____ 9. You can move to each subsequent step in any Wizard dialog box by clicking the ____ button.
a. / Advance / c. / Finishb. / Next / d. / New
____ 10. If you are unable to see all of the fields on your display; to display more of the available data, click the ____.
a. / Maximize button on the Database windowb. / scroll bar
c. / Shutter Bar Open/Close Button on the Navigation Pane
d. / either a or c
____ 11. A form is used to ____.
a. / select records that meet specific criteriab. / enter, edit, and view records in a database
c. / automate the retrieval and update process
d. / none of the above
____ 12. The fastest way to create a form is to use the ____.
a. / Form tool / c. / Create form tabb. / Form Wizard / d. / Form Design view
____ 13. Data can be formatted prior to printing by creating a ____.
a. / table / c. / new databaseb. / spreadsheet / d. / report
____ 14. In the figure above, each column represents a ____.
a. / record / c. / tableb. / field / d. / primary key
____ 15. A(n) ____ places all the fields from a selected table (or query) on a report.
a. / AutoReport Wizard / c. / Report toolb. / Report Template / d. / New Report button
____ 16. In the figure above, the large arrow labeled 1 is used to ____.
a. / navigate to the next record / c. / select all the records in the tableb. / select the current record / d. / copy the records in the table
____ 17. In the figure above, the large arrow labeled 3 is used to ____.
a. / switch to design view / c. / close Accessb. / save the data in the table / d. / close the table
____ 18. In the figure above, the large arrow labeled 4 is pointing to a circled area used to ____.
a. / see how many records are in the table / c. / see the number of the current recordb. / move to the next record / d. / all of the above
____ 19. The Create tab has options to create ____.
a. / reports / c. / tablesb. / forms / d. / all of the above
____ 20. After a new database has been created, the ____ window becomes the main control center for that database.
a. / Access / c. / Controlb. / Wizard / d. / Database
____ 21. The ID column that Access automatically adds ____.
a. / is created by default / c. / can be renamedb. / inserts a primary key field / d. / all of the above
Case-Based Critical Thinking Questions
Case 1
Pine Hill Music School After giving private piano lessons from her home for several
years, Yuka Koyama founded the Pine Hill Music School in Portland, Oregon. Because of
her popularity as a music teacher, Yuka attracted top-notch students, and her school
quickly established a reputation for excellence. During the past two years, other qualified
teachers have joined Yuka to offer instruction in voice, violin, cello, guitar, percussion,
and other instruments. As her school continues to grow, Yuka wants to use Access to
keep track of information about students, teachers, and contracts. You’ll help Yuka create
and maintain an Access database to store data about her school.
____ 22. If Yuka discovers that she wants to delete a column she doesn’t need, she would select an entire column of an Access table by clicking the ____ selector.
a. / column selector / c. / record selectorb. / row selector / d. / datasheet selector
Case 2
Parkhurst Health & Fitness Center After years working in various corporate settings, Martha Parkhurst decided to turn her lifelong interest in health and fitness into a new business venture and opened the Parkhurst Health & Fitness Center in Richmond, Virginia. In addition to providing the usual fitness classes and weight training facilities, the center also offers specialized programs designed to meet the needs of athletes—both young and old—who participate in certain sports or physical activities. Martha’s goal in establishing such programs is twofold: to help athletes gain a competitive edge through customized training, and to ensure the health and safety of all participants through proper exercises and physical preparation. Martha wants to use Access to maintain information about the members who have joined the center and the types of programs offered. She needs your help in creating this database.
____ 23. To make sure that Martha’s database is protected against loss, damage, or file corruption, what should she do?
a. / Compact and repair the database on the hard drive.b. / Convert the database to Access 2002.
c. / Make a back-up copy on the hard drive.
d. / Set a database password.
____ 24. If Martha only needs to print the first two pages of a six page report, she should click File, and then click Print. Then she should click ____.
a. / Quick Print / c. / Selected Recordsb. / the pages, one by one / d. / Print Preview
Case 3
Rossi Recycling Group The Rossi Recycling Group is a not-for-profit agency in Salina, Kansas that provides recycled household goods to needy people and families at no charge. Residents of Salina and surrounding communities donate cash and goods, such as appliances, furniture, and tools, to the Rossi Recycling Group. The group’s volunteers then coordinate with local human services agencies to distribute the goods to those in need. The Rossi Recycling Group was established by Mary and Tom Rossi, who live on the outskirts of Salina on a small farm. Mary and Tom organize the volunteers to collect the goods and store the collected items in their barn for distribution. Tom wants to create an Access database to keep track of information about donors, their donations, and the human services agencies.
____ 25. Tom would like to print receipts for donations. How could he print just the current record showing an individual’s donations when he is in a form?
a. / Just click the Print button.b. / Use the Print dialog button.
c. / Click the Selected Record(s) option button in the Print dialog button.
d. / Click the Office button.