Microsoft Access 2010

May 12th, 2014
Price: $15 USD

Question description

Start Access. Open the downloaded file named Go_a01_Grader_IR.accdb.
Create a new table in Datasheet view. Change the field name of the ID field to CoordinatorID. Add the fields EventID, Coordinator LName, Coordinator FName, Telephone, Email, and Status (in that order), using the Text data type.
Change the Data Type of the CoordinatorID field to Text. Save the table as Event Coordinators. Switch to Design View and ensure that the CoordinatorID field is set as the Primary Key. Switch back to datasheet view.
Add the following new record to the Event Coordinators table and then close the table:

CoordinatorID EventID Coordinator LName Coordinator FName Telephone Email
Append a copy of the records from the downloaded Excel file named a01_Event Coordinators.xlsx to the Event Coordinators table (the table will now contain five records).
In Design view of the Event Coordinators table, delete the Status field. Change the field size of the CoordinatorID field to 5. View the table in Datasheet view and save the changes when prompted.
Resize all of the columns in the table to give each one the best fit. Save the table.
With the Event Coordinators table open in Datasheet view, use the Simple Query Wizard to create a query based on the table. Add all of the fields to the query except the CoordinatorID field (in their displayed order) and click Next. Save the query as Event Coordinators Query and then click Finish. Close the query.
Create a simple form based on the Event Coordinators table that will open in Layout view. Save the form as Event Coordinators Data Entry. View the form in Form view. Close the form.
With the Event Coordinators table open in Datasheet view, create a simple report that will open in Layout view. Save the report with the name Event Coordinators. Use the property sheet to set the widths of the CoordinatorID, EventID, and Telephone fields to 1 inch, Coordinator LName and Coordinator FName to 1.3 inches, and Email to 1.75 inches.
Move (do not resize) the page number control to the left so that its right border aligns with the right margin of the report. Sort the report in ascending order by the Coordinator LName field. Close the report, save the changes when prompted, and then close the Event Coordinators table.
Right-click the Event Coordinators table in the Navigation Pane and then click Table Properties. Enter This table will relate booked events with their coordinators. (type the period) in the Description and then click OK.
In the Event List form, in the first record row, enter Pool Party as the Title, 7/17/2014 12:00:00 PM as the Start Time, 7/17/2014 5:00:00 PM as the End Time,Event around pool will offer hot/cold appetizers and specialty martinis. (type the period) as the Description, and Pine Valley Country Club as the Location.
Click the New Event hyperlink in the Link Bar above the record. In the Event Details form that opens, enter Bridal Shower as the Title, River Walk Club as the Location, 7/16/2014 2:30:00 PM as the Start Time, 7/16/2014 5:30:00 PM as the End Time, and Light luncheon with sparkling wine will be served to approx. 80 guests. (type the period) as the Description. Click the Save and New hyperlink and then close the Event Details form.
In the Navigation Pane, change the view to Tables and Related Views.

Tutor Answer

(Top Tutor) eriqueJ
School: Duke University

Studypool has helped 1,244,100 students

Review from student
" Thanks, good work "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors