ACCESS
Assignments
Text Information
The text for this portion of the
class is “The O’Leary Series, Office Access 2003”.
General Information
The Chapter Learning
Activities below are for you to learn the MS Access skills required to complete
the assignment and designed to be pre-work for the lab. These are not to
be turned in and you can ignore any place they require you to print.
The Step by Step exercises
below are the materials that must be turned in throughout the semester.
These are found at the end of the chapter starting on the page listed below
e.g. (AC1.78) and have a red bar on top of the page. Always be
sure your forms and printouts look correct. Adjust the spacing and alignment
properly; make sure there are no spelling/typing errors in the data, and use
appropriate clip art where required. To see common errors and the corresponding
point deductions for each lab click here.
Finally, On Your Own exercises
for each chapter are designed to give you a chance to practice your skills
without step by step instructions. They can be found at the back of the
chapter starting on the page listed for each lab e.g. (AC1. 81) and have a blue
bar on the top of the page. This is similar to the comprehensive case you
will be working on in Lab 5. You will have limited time for Lab 5 case an it is a similar format to these exercises
Assignments
Prior to class you should read the
chapter and complete the Chapter Learning Activities (in blue) which are
embedded in the chapters. These assignments will not be turned in, however, completion of these assignments will provide
you with the necessary knowledge to complete the graded assignments. In
the lab or at home, you will complete and then turn in the assignments called
out in the instructions that come from the Yellow “Step-by-step Lab
Exercises”. These assignments appear in the back of each chapter, so
bring your book to class.
Download the necessary databases
before class to a flash drive or directly from the website in the lab
(preferred). In addition, print and bring with you the Assignment Details
page so you know which “Step-by-step Lab Exercise” assignment that you should
turn in. We will start these assignments together, in the lab, but you may need
additional time on your own to complete them.
Assignments are due on (see
syllabus). Each assignment is worth (see syllabus) points.
It is recommended that you try to
complete each project or assignment (up to where the instructions tell you to
close the database and exit Access) in one sitting, especially if you are using
lab computers. Note: Save a softcopy of ALL of your work. You will be
responsible for your own work.
Assume you are
completing these assignments for your boss and make them look
professional. Attach a coversheet
containing your name, section, date the assignment, and staple all the pages
together before turning in. You must complete all your own work; copies
will not be accepted.
The Step by Step
Exercises below are color coded. The coding schemes are as follows:
Lab Instructions
(Black)
Data
(Green)
Print
Steps (Red)
Hints
and or databases for use in the lab (Blue)
Exercise
Databases
When using a lab computer, we
recommend that you work directly from the hard drive by transferring your
downloaded files from the website or flash drive to the desktop. When you
have completed the assignment, save the file to a floppy disk or flash drive,
and then also email the files to yourself as a backup. Floppy disks are
notoriously unreliable! Remember to save you work and then delete your
files from the desktop before you leave as they may not be there when you
return, and we want to keep the lab computers clean. If it has not been
said enough, SAVE YOUR WORK!!!
Guidelines to Follow
- You
may not be able to complete lab assignments in the class time
allotted. If this is the case, you must complete the assignment on
your own time and turn it in on the due date (see syllabus for due dates).
The computer lab is available in the business building (to be announced in
class).
- Always
work off the desktop or hard drive. Do not start working from your
diskette. It will slow your work down, and there’s a possibility of
losing your information.
- Save
a softcopy of all projects that you will turn in. (The best way to
do this is by emailing yourself the information as an attachment. i.e.
Yahoo! or any email with sufficient space)
- Do
your own work! Copying others work can result in an automatic
failure for the assignment and most likely the entire course.
- Read
each chapter and attempt the hands-on activities before you begin working
or the assignment will not make sense (unless you have previous knowledge
of working with MS Access).
- Homework
is due at (see syllabus)
- Please
format all work so it complete and readable – point deductions occur for
truncated fields, word wraps, reports on multiple pages horizontally, etc.
Lab 1 – Creating a Database
PRE-WORK ASSIGNMENT
(Chapter Learning Activities): pgs
I.1-I.26, AC1.1-AC1.62 - White pages with Blue graphics inside the
chapter
POST LAB PRACTICE (On Your own): Expense Tracking Database (AC1.82) - Yellow pages at the end of the chapter with Blue bar
TURN-IN ASSIGNMENT (Step
by Step Exercise): Adventure Travel
In this assignment you
will create a new database, create a table, enter, edit and delete table data,
modify fields, change column widths, and preview information, and close and
open and existing database and table. Follow the directions below to
complete the lab.
ADVENTURE TRAVEL
You have just been hired by Adventure Travel
a.
Create a database named ‘Adventure Travel’. Design a table using the following
field information and copy repetitive text where possible:
|
Field
Data |
Type |
Description |
Field
Size |
|
Package |
Text |
Unique
three-digit package number |
3 |
|
Destination |
Text |
|
20 |
|
Length |
Text |
Enter
as # days, # nights |
20 |
|
Description |
Text |
Package
details (25 words or fewer) |
25 |
|
Accomodations |
Text |
Name
of hotel, motel, or other lodging |
20 |
|
Contact |
Text |
Name
of contact person |
20 |
|
Phone |
Text |
Enter
contact phone number as ###-###-#### (e.g., 800-555-5555) |
15 |
PRINT the “table design
view” after completion (PRINT 1) **
Hint: see Print Table Design View (using print screen) at the
bottom of this document
b.
Make the Package field the primary key field.
c.
Change the Contact and Accommodations field size to 30.
d.
Change the size of the Description field to 50 and its description to 15 words
or fewer.
e.
Save the table as ‘Packages’
PRINT the “entire table
design” after making the changes in steps b, c & d (PRINT 2) Hint: see Print Entire Table Design (using MS Access) at the bottom of
this document
f.
Enter the following records into the table in Table Datasheet view:
|
Record 1 |
Record 2 |
Record 3 |
|
010 |
053 |
112 |
|
|
Circle
C Ranch |
|
|
2
days, 1 night |
7
days, 6 nights |
5
days, 6 nights |
|
Lodging
and lift tickets |
Activities
arranged by ranch staff |
Landmarks
and galleries |
|
|
Ranch
House |
Washington
Hotel |
|
Linda
Fairlane |
Rebecca
Lewis |
Frank
Miran |
|
800-555-2525 |
602-555-0932 |
212-555-0048 |
g.
Add the following records into the table in Data Entry:
|
Record 1 |
Record 2 |
|
119 |
052 |
|
|
|
|
3
days, 2 nights |
2
days, 1 nights |
|
Accommodations
and show tickets |
Accomodations
and park passes |
|
Grand
Hotel & Casino |
Mega
Motel |
|
Brian
Thompson |
Carol
Davis |
|
800-555-7521 |
800-555-1122 |
h. Redisplay all the records in the
table.
PRINT the TABLE DATASHEET view after making the changes in steps f,
g, &h (PRINT
3)
i.
Adjust the column widths using Best Fit.
j. Edit the record for Package #119
to replace Brain Thompson’s name with your name.
k. Change the description for
PRINT the TABLE DATASHEET view after making the changes in steps I ,j & k (PRINT 4)
l. Delete record 053.
m. Change the
page orientation to landscape. Change the left and right margins to ˝-inch.
n. Preview and PRINT the table, then save and close it. (PRINT 5)
Lab 2 – Modifying a Table and Creating a Form
PRE-WORK ASSIGNMENT
(Chapter Learning Activities): pgs AC2.1-2.46 - White pages with Blue graphics inside the chapter
Required
Files/Databases: ac02_Employees
(database)
POST LAB PRACTICE (On Your own): Employee Database Update (AC2.64) - Yellow pages at the end of the chapter with Blue bar
TURN-IN ASSIGNMENT (Step by Step Exercise): LearnSoft
Product Development Database (AC2.60) -
Yellow pages at the end of the chapter with Red bar
Required
Files/Databases: ac02_LearnSoft
(database)
In this assignment you
will navigate large tables, customizing and inserting tables, hiding and
redisplaying fields, finding and replacing data, sorting records, formatting
the datasheet, creating and using forms, previewing and printing a form,
identifying object dependencies and setting database and object properties, and
documenting a database. Follow the directions below to complete the lab.
LEARNSOFT PRODUCT DEVELOPMENT
DATABASE
LearnSoft
Inc., which develops computer curriculums for grade K-8, has just hired you to
update and maintain their software database. Some of the tasks your
manager asks your to accomplish involve correcting some
known errors and applying some validation rules. She would also like you
to create a form, shown here, which will make it easier to enter new software
titles.
a.
Open the database file named ‘ac02_LearnSoft’ and the table named ‘Software’.
b. The
name of the CalcIt series has been changed to SolveIt. Use the Replace command to find the two records with
this title and change them.
c. The program called ReadWrite
was never released and has been replaced by separate reading and writing
programs. Find and delete this record.
d.
Switch to Design view and add a validation rule and text to the Grade Level
field so that it only allows an entry of K-2, 3-5, or 6-8 (Hint: In the
Validation Rule setting type: “K-2” or “3-5” or “6-8”).
PRINT the “table design view” after making the changes in steps b, c
& d (PRINT 1)
e. Add a field above Release Date to specify the name of
the project manager for each title:
Field name: Project Manager
Data type: Text
Description: PM name
Field size:
20
PRINT the “entire table
design” after making the changes
required in step e (PRINT 2)
f. Return to datasheet view and hide the Title through
Key Topic columns. Next, you need to update the table by filling in the new
field for each record. Each program has a unique two-digit prefix that
identifies its project manager. Using first Malcolm Duggan and other names of
your choice, complete the Project Manager field for
each record. For example, Malcolm managed products with the 24 prefix. Unhide
and Best Fit the columns when you are
done.
PRINT the datasheet view with all the records updated in step f
(PRINT 3)
g. Create a columnar form using the Form Wizard. Use the
Software table and include all the fields in their current order. Choose the
columnar layout and Blends style. Use the name LearnSoft
Programs for the form.
h. Use the form to enter a new record for a software
program called Around the World, Product Code 78-0220, which is currently in
development for grades 3-5 to introduce students to international cultures.
Enter your name as the Project Manager and today’s date as the Release Date.
Preview and PRINT the form for this new record (PRINT 4). Example
below
|
Release
Date |
3/5/2001 |
|
Product
Code |
77-0101 |
|
Title |
Remember
When |
|
Subject |
History |
|
Grade
Level |
K-2 |
|
Key
Topics |
Famous
people and major event |
|
Project
Manager |
Ron
Bowers |
|
Release
Dates |
6/30/1999 |
|
Product
Code |
77-0102 |
|
Title |
Remember
When |
|
Subject |
History |
|
Grade
Level |
3-5 |
|
Key
Topics |
|
|
Project
Manager |
Ron
Bowers |
|
Release
Dates |
9/19/2000 |
|
Product
Code |
77-0103 |