Chat with us, powered by LiveChat Your company handles room registration, speaker coordination, and other functions for national conferences that are held at your campus throughout the year. The sales department mails schedule | Wridemy

Your company handles room registration, speaker coordination, and other functions for national conferences that are held at your campus throughout the year. The sales department mails schedule

Exp19_Access_Ch09_CapAssessment – National Farm and Agriculture Conference 1.0

  

Project Description:

Your company handles room registration, speaker coordination, and other functions for national conferences that are held at your campus throughout the year. The sales department mails schedules to speakers and building coordinators. The speaker database was modified by unauthorized personnel, and some of the changes need to be reversed. For example, all of the relationships were deleted; they need to be recreated. You have been asked to analyze the database, fix the relationships, and make the database more secure to avoid this situation in the future. The database tables may already be normalized; however, you need to examine the tables to verify this.

     

Open   the downloaded Access file named Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb.   Grader has automatically added your last name to the beginning of the   filename.

 

Open   the Relationships window. Add the Presenters, ExhibitPresenter, Exhibits,   and Locations tables to the   layout.

 

Create   a relationship between the Exhibits   and ExhibitPresenter tables,   ensuring you check the Enforce   Referential Integrity and Cascade   Update Related Fields options.

 

Create   a relationship between the Exhibits   and Locations tables, ensuring you   check the Enforce Referential   Integrity and Cascade Update   Related Fields options.

 

Create   a relationship between the Presenters   and ExhibitPresenter tables,   ensuring you check the Enforce   Referential Integrity and Cascade   Update Related Fields options. Save, and close the Relationships window.

 

Open   the Performance Analyzer dialog   box and select all tables. You   should be given two ideas. You decide not to implement the changes; close the   Performance Analyzer. Open the Database Documenter tool. Check the Exhibits table, and set the options   so Properties, Relationships, and Permissions by User and Group are   set. Include Names, Data Types, and Sizes for fields, and Nothing   for Indexes. Close the Object   Definition report without saving.

 

Create   a new form using the Form tool   based on the Presenters table.   Save the form as Add or Edit Presenters and   close the form.

 

Create   a navigation form based on the Vertical   Tabs, Left template.

 

Add   the Add or Edit Presenters form to   the first position.

 

Add   the Current Presenter Schedule   report to the second position.

 

Add   the Locations report to the third   position.

 

Add   the Presenters report to the   fourth position. Save the Navigation form with the default name.

 

Set   the database to open the navigation form when the database opens.

Papa_Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb

PresenterID ExhibitID mSysRowId
1 1 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
1 4 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
1 9 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
1 10 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
1 13 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
1 14 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
2 1 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
3 2 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
3 6 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
3 9 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
4 9 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
4 12 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
5 2 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
5 7 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
5 13 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
6 6 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
7 2 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
7 3 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
7 8 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
7 12 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
8 9 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
8 10 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
9 13 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
10 5 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
10 8 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
10 11 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
11 2 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
12 6 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
13 2 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
13 7 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
13 9 K6Jx7nNx5xKyzOzDy7qqPN00/Fm0QYSIBzTHHj8XE8s=-~1f8y7FV9ypjY2N8IBbdQlg==
ExhibitID ExhibitTitle LocationID Date StartingTime mSysRowId
1 Skills Competition I 101 2020-10-01 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
2 Rabbit Show 103 2020-10-01 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
3 Dairy Show 104 2020-10-01 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
4 Sheep and Goat Show 101 2020-10-01 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
5 Swine Show 101 2020-10-02 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
6 Vegetable Exhibit 102 2020-10-02 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
7 Breeding Techniques 105 2020-10-02 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
8 Virtual Garden Tour 105 2020-10-02 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
9 Horticulture 104 2020-10-02 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
10 Recruiting for Your Chapter 102 2020-10-03 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
11 Herb Exhibit 103 2020-10-03 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
12 Skills Competition II 101 2020-10-03 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
13 Basic Animal First Aid 104 2020-10-03 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
14 Volunteer Opportunities 101 2020-10-03 1899-12-30 lr1LTKeypthEWe/hlm3S+sZ/jQjjO6HbKo/iSlVHAPY=-~Pu5H+TnnAuY1j9CYJtZfyw==
LocationID Capacity Outdoors Refreshments Notes mSysRowId
101 125 true false Main stage A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
102 75 true true A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
103 65 true true A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
104 35 true false Small display outside the main office A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
105 75 false true A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
106 75 true true A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
107 35 true true A8AmYvvjtUrMqKEYJyHArrnh2/WP1NKauAZ9oDl5XpE=-~2CvlcHz8YiDv0nBigi+N7w==
ID mSysRowId
1 rG3hxIuxfDZtJTw3dHgRm1UfdKGA0edTK7CxGddfeaE=-~TlHyhu5lDlX6ZiRALuE2Wg==
PresenterID FirstName LastName Address City State ZipCode mSysRowId
1 Brent Garrett 368 Graham Avenue Graham KY 42344 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
2 Gloria Sandoval 139 Park Avenue Benton IL 62812 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
3 Faye Ramirez 182 Route 20 Monroe LA 71207 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
4 Olga Taylor 122 East 24th Street Guys TN 38339 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
5 Emanuel Chavez 244 Curtis Place Harrisburg PA 17128 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
6 Sheri Williamson 100 20th Avenue Waynesburg KY 40489 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
7 Irma Ferguson 262 Graham Avenue Stem NC 27581 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
8 Darin Clayton 355 Curtis Place Fort Totten ND 58335 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
9 Andre Gilbert 372 East 21st Street Bayamon PR 00958 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
10 Billie Barnett 360 Graham Avenue Higden AR 72067 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
11 Rudolph Cooper 15 Ryle Avenue Radersburg MT 59641 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
12 Joseph Hamilton 253 Main Street Deer Grove IL 61243 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
13 Ginger Silva 33 Main Street Willard UT 84340 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
14 Roger Hines 196 Curtis Place La Mirada CA 90637 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
15 Jody Nichols 44 Montclair Avenue Bloomington IL 61704 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
16 Gertrude Fernandez 166 Market Street Peoria IL 61641 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
17 Florence Pratt 10000 SW 59 Court Lake Norden SD 57248 j0zNuwDmCQ4qRJF7Qt5pJOUP0mQ+0qx74TP4FyrI/Lg=-~VVPzL8QhcJI1739/fjIrXA==
ID FirstName LastName Address City StateProvince PostalCode FeePaid mSysRowId
8 Tatiana Toribio 124 West Windmore Dr New Fairfield CT 6812 true
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date, Exhibits.StartingTime FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.[ExhibitID] = ExhibitPresenter.ExhibitID) ON Presenters.[PresenterID] = ExhibitPresenter.PresenterID;
SELECT DISTINCTROW * FROM Locations;
SELECT DISTINCTROW * FROM Presenters;
SELECT Presenters.FirstName, Presenters.LastName, Exhibits.ExhibitTitle, Exhibits.LocationID, Exhibits.Date FROM Presenters INNER JOIN (Exhibits INNER JOIN ExhibitPresenter ON Exhibits.[ExhibitID] = ExhibitPresenter.ExhibitID) ON Presenters.[PresenterID] = ExhibitPresenter.PresenterID;

EX19_AC_CH09_GRADER_CAP_AS_Instructions.docx

Grader – Instructions Access 2019 Project

Exp19_Access_Ch09_CapAssessment – National Farm and Agriculture Conference 1.0

Project Description:

Your company handles room registration, speaker coordination, and other functions for national conferences that are held at your campus throughout the year. The sales department mails schedules to speakers and building coordinators. The speaker database was modified by unauthorized personnel, and some of the changes need to be reversed. For example, all of the relationships were deleted; they need to be recreated. You have been asked to analyze the database, fix the relationships, and make the database more secure to avoid this situation in the future. The database tables may already be normalized; however, you need to examine the tables to verify this.

Steps to Perform:

Step

Instructions

Points Possible

1

Open the downloaded Access file named Exp19_Access_Ch09_CapAssessment_National_Farm_and_Agriculture_Conference.accdb. Grader has automatically added your last name to the beginning of the filename.

0

2

Open the Relationships window. Add the Presenters, ExhibitPresenter, Exhibits, and Locations tables to the layout.

8

3

Create a relationship between the Exhibits and ExhibitPresenter tables, ensuring you check the Enforce Referential Integrity and Cascade Update Related Fields options.

10

4

Create a relationship between the Exhibits and Locations tables, ensuring you check the Enforce Referential Integrity and Cascade Update Related Fields options.

10

5

Create a relationship between the Presenters and ExhibitPresenter tables, ensuring you check the Enforce Referential Integrity and Cascade Update Related Fields options. Save, and close the Relationships window.

10

6

Open the Performance Analyzer dialog

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA