Assignment 1 – MS Access Non-Procedural Approach

Read the MS Access tutorials at these websites: http://www.fgcu.edu/support/office2000/access/

http://www.functionx.com/access/

Focus on the information related to tables, queries, forms, and reports.

Do Tutorials 1 through 5 under the Access Internet Assignments from this website:

http://www.course.com/downloads/newperspectives/office2000/access_main.cfm

You are asked to download the lexus.mdb database in several of the tutorials. However, you should download it once for Tutorial 1 and then use the modified database for the other tutorials. You should do the five tutorials in sequence starting with 1.

In the tutorials, if you are asked to located models of cars or dealerships in states that you have difficulty finding feel free to substitute more current models and information from Oregon.

When asked to print, you do not need to print the entire object, only a portion of it in order to save paper. You may do a screen print of abbreviated information displayed on the monitor by using the Alt/PrtScn key sequence and then pasting the clipboard contents into a word processor for printing.

Turn in the printouts you are asked to generate. These may be turned in in class or in the CIT281 drop box in Deschutes Hall. Also, upload the final version of your lexus.mdb database with your changes to the DropAssignmentsHere folder on the Andromeda2 server. The filename should start with your last name then first initial followed by the assignment number then database name, for example, Bricherg_1_Lexus.mdb.

1. Tutorial 1 - [10 points]

2. Tutorial 2 - [10 points]

3. Tutorial 3 - [15 points]

4. Tutorial 4 - [15 points]

5. Tutorial 5 - [20 points]

Assignment 2 – MS Access and VBA Basics

Read the concept lessons for Tutorials 1, 2, and 3 in the Zak text.

1. Follow the steps in the Access Lesson for Tutorial 1, then do Exercise 1 [20 points] and Exercise 4 [5 points] on pp. 78-79.

2. Follow the steps in the Access Lesson for Tutorial 2, then do Exercise 1 [15 points] and Exercise 5 [5 points] on pp. 150-151. In Exercise 1, print the info you saved from the Immediate window rather than saving it to a file.

3. Follow the steps in the Access Lesson for Tutorial 3, then do Exercise 1 [20 points] and Exercise 7 [5 points] on pp. 203-206.

Turn in the hardcopy output you are asked to generate in class or in the drop box in Deschutes Hall. Also, upload the finished database files from each of the exercises to the DropAssignmentsHere folder on the Andromeda2 server. The filenames should start with your last name then first initial followed by the assignment number then database name, for example, Bricherg_2_Filename.mdb.

Assignment 3 – Variables and Selection with VBA

Read the concept lessons for Tutorials 4, 5, 6, and 7 in the Zak text.

1. Follow the steps in the Access Lesson for Tutorial 4, then do Exercise 1 on pg. 264 [20 points] and Exercise 5 on pg. 266 [5 points].

2. Follow the steps in the Excel Lesson for Tutorial 5, then do Exercise 3 on pg. 296-297 [20 points] and Exercise 9 on pg. 300 [5 points].

3. Follow the steps in the Word and Access Lessons for Tutorial 6, then do Exercise 6 on pg. 374 [5 points] and Exercise 3 on pg. 388 [20 points].

4. Follow the steps in the Access Lesson for Tutorial 7, then do Exercise 1 on pg. 446 [20 points] and Exercise 5 on pg. 448 [5 points].

Upload the finished database, spreadsheet, and word processing documents from each of the exercises to the DropAssignmentsHere folder on the Andromeda2 server. The file names should start with your last name then first initial followed by the assignment number then the filename and appropriate extension, for example, Bricherg_3_Filename.mdb.

Assignment 4 – Selection, Repetition, and Dialog Boxes with VBA

Read the concept lessons for Tutorials 8, 9, 10, and 12 in the Zak text.

1. Follow the steps in the Word and Access Lessons for Tutorial 8, then do Exercise 5 on pg. 496 [5 points] and Exercise 2 on pg. 505 [20 points].

2. Follow the steps in the Excel Lesson for Tutorial 9, then do Exercise 1 on pg. 535 [20 points] and Exercise 9 on pg. 539 [10 points].

3. Follow the steps in the Access Lesson for Tutorial 10, then do Exercise 2 on pg. 624 [20 points] and Exercise 7 on pg. 626 [5 points].

4. Follow the steps in the Access Lesson for Tutorial 12, then do Exercise 1 on pg. 783 [20 points].

No printouts required. Upload the finished database, spreadsheet, and word processing documents from each of the exercises to the DropAssignmentsHere folder on the Andromeda2 server. The file names should start with your last name then first initial followed by the assignment number then the filename and appropriate extension, for example, Bricherg_4_Filename.mdb.

Assignment 5 – Special Controls and Automation

Read the concept lessons for Tutorials 13 and 14 in the Zak text.

1. Follow the steps in the Word and Access Lessons for Tutorial 13, then do Exercise 4 on pg. 844 [5 points] and Exercise 3 on pg. 858 [20 points].

2. Follow the steps in the Excel and Access Lessons for Tutorial 14, then do Exercise 3 on pg. 882 [5 points] and Exercise 3 on pg. 911 [20 points].

No printouts required for the three Exercise 3’s. For Exercise 4, show the corrected procedure in hardcopy form. Turn in the hardcopy in class or in the drop box in Deschutes Hall. Upload the finished database, spreadsheet, and word documents from each of the exercises to the DropAssignmentsHere folder on the Andromeda2 server. The file names should start with your last name then first initial followed by the assignment number then the filename and appropriate extension, for example, Bricherg_5_Filename.mdb.