R. Craig Collins > BCIS 1301/COSC 1301/ITSC 1309 > Lab 7

Lab 7 © R. Craig Collins, 2005/9

General Lab Directions
Note: There is not enough time in lecture to cover all the material; read your book BEFORE you begin the lab
Note: Typically labs will require you to invest some time in the lab, outside of class lecture hours

 •Check with your Instructor for due dates 

Complete:

OPTION 1 Update Lab 6 (The easy option)
• Copy your lab 6 folder, rename it lab 7. Rename the database to yourname-lab7.accdb
 • Using your Lab 6 database, apply the following concepts
   • Add at least 5 additional records to each tables
   • Create and save new queries, demonstrating logical operators and 'like', and use one calculation query
     • make sure each query is saved with a meaningful name
   • Modify one of the tables in some way, add a description to a word document of what you modified.
   • In the same Word document, summarize what crosstab queries are,
   • In the same Word document, summarize all of Access Chapter 3, including
     • adding, changing, and deleting records
     • filtering records
     • updating a tables design
     • the difference between regular queries and update queries
     • validation, and
     • sorting
     • Save the Word document in the lab 7 folder as yourname-lab7.docx

Selected Help for Lab 7
Access Tips (based Access 2003, but still illustrative)

OPTION2 Use the book's databases (the harder, time consuming option for people who might actually like using databases)
 • Apply Your Knowledge, p. AC 64 (file required, right click here and choose Save As)
   • You will need to right click the zip file to unzip the database.
   • If you get a message that the extracted database is read only,
      close the database, right click, properties, and get rid of the check mark next to 'Read only'
 • Apply Your Knowledge, p. AC 128 (file required, uses the modified file from Chap 1.)
 • Modification to lab: You MUST save each query, and use a new, meaningful name
 • Summarize the following from Access Chapter 3: updating a table design, look up fields, and sorting.
 • When finished, zip the database with your summary before submitting.

Problems? Zip the entire folder and attach to an email:
       •Send the mail to your instructor, cc yourself
       •The subject line should include your name, your class, your section, and what you are submitting
       •Make sure you attach the zipped file

SUBMITTING THE LAB

• 1. Choose the class for which you want to drop off an assignment.
  2. Find the Dropbox tool, click on it.
  3. Choose the appropriate Dropbox folder, click on it.
  4. Choose [Add a File], then choose [Browse]; you may need to choose (My) Computer first
  5. Find the file that you would like to upload and click open, then choose [Upload]
  6. Type in a short description or comment about the file, if you like.
  7. Select [Add] for any additional files that may be pertinent, and repeat
  8. After your files have been selected, click [Submit]. (To upload and submit you will always click at least twice)
  9. Some files may take a long time to upload (especially if there are graphics in the file).

• Did my file get through?
  1. Go to the Dropbox tool
  2. Click the number under Submissions
  3. All of the assignments that have been submitted will be listed.