CIS 105
Survey of Computer Information Systems
(Addendum to Assignment Schedule)

ESS-LAB-Access

Keys for Success
  • Important: Although you are not required to "submit" all exercises in your lab book, it is important that you work through the steps to ensure you understand how to complete each of the tasks. The skills within the labs build upon each other and will be included in your tests.
  • Your data files can be found on the Essentials Student Data disk which came with your textbook, or online through the CIS105 Technology Toolbox or the link below. You will need to save the files to your USB flash drive.

http://www.mc.maricopa.edu/dept/d07/cis105/student_disks.html  You will need Access 2003 files for these projects. (The Integrating Projects files can ONLY be found here; they were not included on your student data CD.)

You will need your USB Flash drive for these lessons. (The files are too large for floppy disks.)
  • When the book asks you to save to the 3 1/2" A:Floppy drive, you should instead save the files to your USB flash drive to complete your lessons (see syllabus).
  • Each project/lesson may either require you create a file, open a file and back it up to a different name, or both. Be sure to read and follow each step carefully. 
  • Don't forget to read information in the If You Have Problems and the Extending Your Knowledge boxes found throughout the pages of your lab book.

Complete the Following Tasks

1

Read and work through ALL of the Lessons in Projects 1 through 8 in the Microsoft Access 2003 section of your textbook (pp 663-943)

  • You will need your data files (from your data CD or you can download them as indicated above.)
  • Ensure your name is located within each file (add a record with your name for each lesson).
  • Complete all lessons for each project in this section. A list of all of the files you will submit is listed below. Each file name should begin with your last name and the Project # ((i.e. Smith_P1_Personnel_File.mdb) Note: DO NOT use spaces in the file name or it won't upload to WebCT correctly.
  • Upload each file to the Lab-Access Dropbox (Don't click Submit until all files files listed below are uploaded).
40 pts

2

 

 

 

3

Complete and submit all of the following documents through the LAB-Access Dropbox:

Project 5, Challenge 1 - Creating Select Queries and Setting a Sort Order (pg. 875) -

  • Include your name and section number in the report name
  • Save the file as: YourLastName_ Fort_Fun_Query (i.e. Smith_Fort_Fun_Query) Note: DO NOT use spaces in the file name or they may not upload to the dropbox correctly.
  • You do not need to print this document as you will be submitting it online.
20 pts

Integrating Project - Designing & Building a Media Database (Using information you created for COMP - Computers: Tools for an Information Age, pp. 13-394 & 13-395, questions 1 & 2)

  • Note: There is no data file for this -- you will be creating the database based on the information you used in questions 1 & 2 on pp. 13-394 & 13-395 of your COMP textbook.
  • Save the file as: YourLastName_Media (i.e. Smith_Media). Note: DO NOT use spaces in the file name or they may not upload to the dropbox correctly.
  • Create the tables needed for a media tracking/inventory system.  Include the fields within each table, their type, and size.  (Hint:  You may adapt your original answers to the COMP Chapter 13 questions; however you'll want to write it out before you start creating tables in Access). 
  • You should have a minimum of 3 tables and a maximum of 5.  Use logical and related fields.  Keep it professional, non-offensive, do not be silly! 
  • Other requirements:
    • Primary key should be used in the tables.
    • Field Types - a minimum of 3 field types for each table
    • Validation Rules  – a minimum of two validation rules per table with validation text
    • Input Masks - a minimum of one input mask per table
    • Records – each table should contain a minimum of 5 records.
    • Forms – create a form (or multiple forms) that includes fields from all tables.
    • Queries  – Create 6 queries (using the guidelines in the table below). Ensure query names indicate type of query
    • Reports – create a minimum of two reports.  One report must include information from multiple tables.
    • Relationships - Ensure each table is related to at least one other

      Your database will be graded on the following. 

      Primary Key used in each tables       3
      A minimum of two validation rules per table with validation rule text                        6
      A minimum of 3 different types of data fields, i.e. text, numeric, date, currency,  yes/no, etc. per table                                                           6
      A minimum of three and a maximum of five tables                                                 5
      A minimum of one input mask for each table       3
      Queries    (5 pts each)   
      1. Use text data criteria  showing all fields
      2. Use numeric data criteria showing selected fields     
      3. Use comparison operators 
      4. Use compound criteria—one for AND— and one for OR (5 pts ea)
      5. Any other type of query you want.       		 30
      Forms  - create a form(s) ensuring all fields are included for entry.  10
      Reports – create 2 reports of the tables (10 pts each).    
      Be sure to Include multiple tables for one of them (or can base on a query which combines tables)       		20
      Relationships – be sure each table is related to another  2
      Professional, complete, named correctly 5
      Total Points for Media Database 90
90 pts
   
4 Submit when finished using the LAB-Access Dropbox (do not send through email). You will need upload each file. Once all of the files are loaded; then Submit the files. Important: If the files are named incorrectly (without your last name included in the file name or if the name includes spaces) they may not be accepted/graded!
Total
150 pts

LAB-Access Checklist (Files to be Submitted) 

The following 10 files are worth 5 pts for each project and should be submitted to the  Access_Project_Files dropbox (40 pts total):

  • Project 1: Lesson 1-8: YourLastName_P1_Personnel_File.mdb
  • Project 2: Lesson 1-8: YourLastName_P2_PetPals.mdb
  • Project 3: Lesson 1-8: YourLastName_P3_PetPals_Corp.mdb
  • Project 4: Lesson 1-8: YourLastNam_P4_PetPals_Main.mdb
  • Project 5: Lesson 1-6: YourLastName_P5_PetPals_Query.mdb
  • Project 6: Lesson 1-3: YourLastName_P6_PetPals_Forms.mdb
  • Project 7: Lesson 1-2: YourLastName_P7_PetPals_Reports.mdb
  • Project 8: Lesson 1-4: YourLastName_P8_PetPals_Int.mdb
  • Project 8: Lesson 1-4: YourLastName_P8_2005_Sales_Goals_Exp.xls
  • Project 8: Lesson 1-4: YourLastName_P8_Potential_Franchise_Merge_Letter.doc

The following files are worth the points listed and should be submitted to the LAB-Access dropbox (100 points total):

  • Project 5, Challenge 1 - YourLastName_ Fort_Fun_Query (20 pts)

  • Integration Project - YourLastName_Media (90 pts)

All 12 files should be submitted to the LAB-Access dropbox

LATE DEDUCTIONS: (10% each day late; will not be accepted more than one week late).

NOTE:  This schedule may be changed at instructor's discretion.
Revised Aug 16, 2005