Solved

MS Access Lab Exercises (Urgent Need)

Posted on 2004-08-03
6
2,395 Views
Last Modified: 2012-02-15
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
Comment
Question by:dlabraham
6 Comments
 
LVL 18

Expert Comment

by:Data-Man
ID: 11708225
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
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 11709012
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
 
LVL 4

Accepted Solution

by:
szacks earned 500 total points
ID: 11715661
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 49

Expert Comment

by:Gustav Brock
ID: 12635312
Did this work for you?

/gustav
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 13623083
Did you find a solution?

/gustav
0
 

Expert Comment

by:hellonz
ID: 37601622
no so detail
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
table joins in qry 17 65
Display 2 columns in combobox view 8 30
error in For & Next statements 4 24
Pass Variable Form Name to another form in Access 16 21
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question