Microsoft Office Tutorials and References
In Depth Information
Access Chapter 3 Maintaining a Database
Cases and Places continued
•• 4: Updating Your Contacts Database
Make It Personal
Use the contacts database you created in Cases and Places 4 in Chapter 1 on page AC 71 for this
assignment, or see your instructor for information on accessing the ﬁ les required for this topic.
Consider your own personal job situation. Has the focus of your job search changed? Are there speciﬁ c
jobs within the companies of interest that appeal to you? Have you contacted an individual within a
company to express your interest? Create a multivalued ﬁ eld to store those speciﬁ c positions that would
interest you. Review the ﬁ elds in the contacts database. Are there any ﬁ elds you need to add? Are there
any ﬁ elds you need to delete? Are there any tables that need to be deleted? Are there companies that
need to be added to your database? Make any necessary changes to your database structure and update
the database. Using a word processing program, such as Microsoft Word, explain what changes you
made to your database and why you made the changes. Submit the Word document and the revised
database in the format speciﬁ ed by your instructor.
•• 5: Understanding Action Queries, Query Wizards, and Table Design Changes
With a make-table query, a user can create a new table from one or more tables in the database. The
table can be stored in the same database or a new database. As a team, use the Access Help system
to learn more about make-table queries. Then, choose either the Cases and Places 1 database or the
Cases and Places 2 database and create a make-table query. For example, for the Hockey Fan Zone,
the management could create a table named Supplier Call List that would include the item code,
description, and cost of each item as well as the supplier name and telephone number. Write a
onepage paper that (1) explains the purpose for which the new table is intended and (2) suggests at least
two additional uses for make-table queries. Submit the paper and the database in the format speciﬁ ed
by your instructor.
Open the Students database that you created in Chapter 1. As a team, review the data types for
each of the ﬁ elds that are in the database. Do any of these data types need to be changed? For example,
is there a ﬁ eld that should store multiple values? Are there any ﬁ elds that should contain validation
rules? Change the data types and add validation rules as necessary. Examine the tables in your database.
Delete any tables that you do not need. Write a one-page paper that explains your reasons for changing
(or not changing) the structure of the database. Submit the paper and the database in the format
speciﬁ ed by your instructor.
Save the Ada Beauty Supply database as AdaTeam Beauty Supply. Research the purpose of the
Find Unmatched Query Wizard and the Find Duplicates query Wizard. Use the AdaTeam database
and create queries using each of these wizards. Did the queries perform as expected? Open each query
in Design view and modify it, for example, add another ﬁ eld to the query. What happened to the query
results? Write a one-page paper that explains the purpose of each query wizard and describes the team’s
experiences with creating and modifying the queries. Submit the paper and database in the format
speciﬁ ed by your instructor.