To Temple College R. Craig Collins > COSC 1301 > Lab 7
R. Craig Collins > BCIS 1301 > Lab 7
R. Craig Collins > ITSC 1309 > Lab 7

Lab 7 © R. Craig Collins, 2005/6

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 the Instructor for the due date  

Complete:
 • Apply Your Knowledge, p. AC 54 (file required, right click here and choose Save As)
   • You will need to right click the zip file to extract/unzip the database.
   • If you get a message that the extracted/unzipped database is read only,
      close the database, right click, properties, and get rid of the check mark next to 'Read only'
   • If you get a security warning, it is okay to open the file
   • If you get a security warning, do NOT block 'unsafe expressions', as there are none
      • If you are prompted to install Microsoft Jet, say 'Yes'
   • If you get another security warning, choose "Open"
 • Apply Your Knowledge, p. AC 109 (file required, uses the modified file from Chap 1.)
 • Summarize the following from Access Project 3: updating a table design, look up fields, and sorting.

Although the book doesn't require it, for this class you MUST save each query with a meaningful name; when complete zip the database with your summary before submitting.

How To: Access: Lab Notes

 

for Labs that require files to be electronically submitted
 • zip the required file(s) and/or folder(s)
 • rename the zipped file to reflect your name and the lab being turned in
       •Example: yourname-lab1 or yourname-lab1.zip (if your extensions are visible)
 • if by 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
       •Attach the file
 • if by Temple College TCampus by Moodle:
       •Log in to your class, and Click once on the Lab/Assignment Turn in
          •[Browse...] to the file you wish to submit,
          •Choose [Open] to select it
          •Choose [Upload this file]
 • if by Dallas Community College eCampus, by Blackboard
      •Log in to your class, and Click once on the Drop Box/Tools button
      •Select the Digital Drop Box
      •Select the [Add file]
        • For Name, type in the name of the lab
        • For File
           • [Browse...] to the file you wish to submit,
           • Choose [Open] to select it
        • For Comments, include your name, your class, your section, and what you are submitting
      •Select Submit