• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2691
  • Last Modified:

MS Access Lab Exercises (Urgent Need)

I am teaching a database management course and am looking for two MS Access lab exercises that require table creations, relationship development, query and report development  of medium complexity for undergraduate students.  Can you provide a resource that may have these pre-contructed labs with solutions? I need these right away. Lab exercises should last 45-50 minutes.
0
dlabraham
Asked:
dlabraham
1 Solution
 
Data-ManCOOCommented:
Sorry to sound critical, but shouldn't the company your teaching for provide you with the resouces to teach the class...including course materials?  If you are looking for pre-made exercises, they probably exist somewhere, but they may not be free or may not fit your needs.  You may want to search for training materials and then purchase/modify them.

Another thought would be to create them on your own.  Since you are teaching the class, you must have the skills neccesary to develop these labs.  I would think that there is a theme in the course notes and that the exercises should center around that theme.  To pull something off the web and modify it and then pass it off as part of the course sounds almost unethical.  The students deserve more.

When I write training materials I estimate 8 hours of develop time per 1 hour of course.  

Mike
0
 
Gustav BrockCIOCommented:
This sounds strange; to me even "low complexity" would require 45 minutes for each exercise ... I mean, how much can be told on report design in 20 minutes?? Running a wizard is not learning report design.

Somebody are going to be fooled here and that shouldn't be neither you nor the students.

/gustav
0
 
szacksCommented:
I'll agree with the rag-on-you and try to help.

Of course, you'll have to actually write the assignment, I'm just going to give you the ideas.

A company is hiring people and decided to design a database to handle and manage this task. They would like to keep track of all job positions, applicants, applications.
Such that an applicant can apply for multiple job positions multiple times.

For the Job Positions you want to know what the title of the job is what department it is for, when the position opened and when it closed.

For applicants you want to know name, address, 2 telephone numbers.
For applications you want to know which job/s they are applying for and where they heard the company was hiring.

That will take 45 minutes to do correctly.

0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
Gustav BrockCIOCommented:
Did this work for you?

/gustav
0
 
Gustav BrockCIOCommented:
Did you find a solution?

/gustav
0
 
hellonzCommented:
no so detail
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now