Viewing Prior Exams

Amanda will have your prior exams for review tomorrow from 10am - 1pm. I will have your exams available on Monday afternoon from 2pm - 4pm.

Monday, Monday

Two big things happening Monday:

1. Bring your completed project on your flashdrive in an envelope with your name on it. After I grade the projects, you may have the flashdrives back.

2. We will take a 'practice' practical portion of the exam. You will have 45 minutes to complete and if you feel like you were successful, you will remit your file to me. If you complete EVERY query correctly (there are 5), you will be exempt from the practical portion of the exam and will receive an automatic 25/25.

Practice your querying over the weekend! Even you aren't quite up to speed so that you are able exempt the practical portion of the exam I feel confident that the practice exam will do a good job preparing you for the actual exam.

Project Queries

As I stated in class, I am fully expecting for all of your queries for the project to be written and running at the start of class on Wednesday. If you are behind and need help, I have office hours this afternoon, and will answer questions via email (attach your database) during business hours tomorrow (I have plans tomorrow evening, so won't be online).

There are files on Blackboard that provide additional guidance. Please see these files before submitting your file to me via email if you just want a "check" (there are check figures on Blackboard).

My best guess is that you will have the following queries (names might not be exact, that is fine):

qryCashReceipts
qryCreditSales
qryDebitsAR
qryCreditsAR
qryARBalance
qryOverCreditLimit
qryOpenToBuy
qryInvoiceNoPayments

Or some similar list based on how you named the queries. Your DPQ Wednesday will be based on your project.

Querying HOMEWORK

Using The Coffee Merchant database, you need to create employee commission on sales.

There is a file on Blackboard that walks through this query (f. on Querying Warmup, we did a.-e. in class today). You will need it in order to complete your DPQ on Monday. This is an INDIVIDUAL homework assignment. If you run into problems, email me, I will be around quite a bit the end of this week.

Also, please review the Query Help file which discusses Join Properties and how to use null fields in calculations. Here is a quick video on Joins:

Querying

As far as preparing for our querying classes, I would focus on pages 844-855, and Chapter 3 in your book. Practice as well, querying isn't hard, but there is a learning curve. Here is a video to get you started (it is a bit longer than normal, 10 minutes, but he shows how to use criteria and aggregates).



I have posted the file that will the basis of the next few DPQs on Blackboard in case you want to download and familiarize yourselves with the data and layout before attempting the DPQ in class.

Access: Forms

The schedule is actually pretty wrong with regards to the chapter and pages for FORMS. Chapter 6 is where forms are described....as well as some other controls that may come in handy.

Forms are actually pretty easy....here is a quick video on how to create a simple form.

Access: Setting up relationships

Here is a pretty good guide to creating relationships in Access.  NOTE that the relationship between Students and Courses in this example is M:N...thus the Enrollment table is created to break up that many to many into TWO one to many relationships.  Further, while she suggests using Cascading update and delete, I usually hesitate with those, only because you can do more damage than good with those enacted.



I would look over pages 807-844 in your book.