Go19_ac_ch03_grader_3g_as – workshop rooms 1.0
GO19_AC_CH03_GRADER_3G_AS – Workshop Rooms 1.0
In this project, you will use a database to track workshops and the rooms where the workshops are held at a college. You will create forms, add and delete records by using a form, filter records, and modify a form in Layout view and Design view. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.
Start Access. Open the file Student_Access_3G_Workshop_Rooms.accdb downloaded with this project.
View the relationship between the Rooms table and the Workshops table. One room can be used for many workshops. Close the Relationships window.
Use the Form tool to create a form based on the Workshops table. Save the form as Workshop Form and then display the form in Form view. Using the Workshop Form, add the following new record to the underlying Workshops table:
Field
Data
Workshop ID
W-5034
Workshop Name
Job Portfolio
Room ID
RM-208
# Registrations
23
Workshop Category
Guide to Finding a Job
How it Works
1
It only takes a couple of minutes to fill in your details, select the type of paper you need (essay, term paper, etc.), give us all necessary information regarding your assignment.
2
Once we receive your request, one of our customer support representatives will contact you within 24 hours with more specific information about how much it'll cost for this particular project.
3
After receiving payment confirmation via PayPal or credit card – we begin working on your detailed outline, which is based on the requirements given by yourself upon ordering.
4
Once approved, your order is complete and will be emailed directly to the email address provided before payment was made!