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

,

  

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

QUALITY: 100% ORIGINAL – NO PLAGIARISM

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS

The Best Custom Essay Writing Service

About Our Service

We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.

Qualified Writers

Our Guarantees:

CLICK TO SUBMIT YOUR ORDER