I have to due on this Saturday.
Can you do this for me on time?
Thanks
A_CH03_GOV1_EOC_Instructions x
Office 2010 – myitlab:grader – Instructions GO Access Ch. 03 –EOC Project
Career Books
Project Description:
In this project, you will create and modify forms and reports using various techniques. You will add data to a form, delete data from a form, and filter records using criteria.
Instructions:
For the purpose of grading of the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Access. Open the downloaded database named GO_a03_Grader_EOC.accdb. 0
2 Create a simple form based on the Career Book Titles table that will open in Layout view. Save the form as Career Book Titles Form and then view the form in Form view. 4
3 Add the following record to the Career Book Titles Form:
Title ID T-34
Title Effective Networking
Author Last Name Rose
Author First Name Vincent
Publisher ID PUB-100
Category Job Search
Copies On Hand 6
Value of Books 180 8
4 Delete Record 17 (Title ID T-18) from the form. In the warning message, click Yes. 2
5 View the Career Book Titles Form in Layout view and then change the width for the Title ID field text box to 7.5 inches. Save and close the form. 3
6 Use the Form Wizard to create a form based on the Publishers table. Add the Company Name, Rep Last Name, Rep First Name, Job Title, and Phone Number fields to the Selected Fields list (in that order). Click Next two times. Name the form Publishers Form and then click Finish. 8
7 View the Publishers Form in Layout view. Select all of the controls and apply the Stacked layout. Change the theme of only the selected objects to Couture. 4
8 Select the title, Publishers Form. Change the font size to 16, apply bold formatting, and change the font color to Brown, Accent 6, Darker 50% (under Theme Colors). 3
9 View the Publishers Form in Design view. Increase the height of the Form Footer section to 0.5 inches. Add a label control to the Form Footer section so it is left aligned with the other controls in the form. Type Created by Lianna Jacobson and then change the font color of the label to Brown, Text 2 (under Theme Colors). Save the form. 4
10 View the Publishers Form in Layout view. From the Field List task pane, add the Publisher ID field to the form above the Company Name field. Close the Field List task pane and then reposition the Rep First Name field so that it is above the Rep Last Name field. Save the form. 5
11 View the Publishers Form in Form view. Add the following record to the form:
Publisher ID PUB-111
Company Name Associated Publishers
Rep First Name Elizabeth
Rep Last Name Cassini
Job Title Sales Associate
Phone Number (703) 555-0857
Close the form. 6
12 View the Career Book Titles Form in Form view. Use Filter by Form to find the titles in the Resumes or Job Search categories (the filtered form will display fourteen records). Save and close the form. 5
13 Create a blank report. Using the Field List task pane, from the Publishers table, add the Company Name, Rep First Name, Rep Last Name, and Phone Number fields (in that order) to the report. Close the Field List task pane and then change the theme of this object only to Equity. 8
14 Change the width of the Company Name column to 2.3 inches. Add a title to the report using the text Reps Phone List and change the font size of the title to 14. 5
15 Apply bold formatting to the column headings in the report. Sort the Company Name field in alphabetical order. Save the report as Reps Phone List and then close the report. 9
16 Use the Report Wizard to create a report based on the Career Book Titles table. Add the Category, Title, and Value of Books fields to the Selected Fields list (in that order). Click Next one time. 5
17 Group the records by the Category field and then click Next. Sort the records by Title in ascending order, modify the Summary Options to sum the Value of Books field, and then click Next two times. Name the report Book Values by Category Report and then click Finish. 7
18 View the Book Values by Category Report in Layout view and change the theme for this object only to Opulent. Select the title of the report. Apply bold formatting, and change the font size to 14. Delete the Summary for ‘Category’ control. 7
19 Change the width of the Sum and Grand Total text box controls to 1 inch. Increase the width of the Grand Total label control to 1.5 inches. 3
20 Open the Group, Sort, and Total pane. Modify the setting to keep a whole group of records together on one page. Close the Group, Sort, and Total pane. Print Preview the report. Save and close the report. 4
21 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0
Total Points 100
Updated on: 5/19/2012 2 A_CH03_GOV1_EOC_Instructions x
GO_a03_Grader_EOC.accdb
Title ID Title Author Last Name Author First Name Publisher ID Category Copies On Hand Value of Books mSysRowId
T-01 Competitive Interview Prep Hubert Gretchen PUB-100 Interviewing Strategies 4 ¤ 175.00 1HmqfbOg/i9phzYJRxcJuY0J19L7fQ+i886xlks7TVU=-~NBAjdl3JtEaC5Ky4mxxHfA==
T-02 Conversation Ice Breakers Stein Herbert PUB-108 Interviewing Strategies 1 ¤ 90.00 8NjjNlosciM0xWDZ9t4wmdMr69PvdnOLZoB0AM3lM8M=-~OccdO+fvs8upDrAjqnHyew==
T-03 Dressing for Interview Success Thornton Perry PUB-102 Interviewing Strategies 4 ¤ 175.00 xRagPG4n2hQtzqaSmJYTd+U3ozCi5UfYFbBeCS6Cop8=-~NZ46ICxM6HazvPIEa5O68g==
T-04 Fifty Standard Interview Questions Becker Colin PUB-103 Job Search 8 ¤ 250.00 ToK+wx0C/50DQ4pHB4/X099Uy/SqEaNZJncSFkrtB3A=-~lKj1EE/lEIHTDShZp5KUzg==
T-05 Hot Jobs Sinclair Janice PUB-104 Job Search 3 ¤ 200.00 4rqIoz3mFgYOtn3RbG3b6Vnf79wjOoQ0P0gyztuCnXQ=-~yisYxLMijoQmcSp4zH50TA==
T-06 Job Fair Success Cunningham Charise PUB-105 Job Search 10 ¤ 450.00 OeUuiBfqtBlNunS3TxX0aNgrB6nsdWOj5S0C3z4Fhwk=-~P+aqJxTWqYRpyy/qcy0jNg==
T-07 Phone Interview Success Chu Fong PUB-100 Interviewing Strategies 10 ¤ 420.00 dvjXtazIOEhtJlkM4185W4DGMmO41dRDOrm5eWVRXKo=-~v/F/PqDA8x1pe/Qe5jBfhQ==
T-09 After the Interview Ramirez Raphael PUB-102 Interviewing Strategies 12 ¤ 525.00 PvT4jYCfL3u0swO4ZTCYtCkWOeqA5VnwdmSWfQ0woVM=-~TOvogyDLF/9/VKjtFczxuQ==
T-10 Entry Level Job Search Doyle Caryn PUB-103 Job Search 5 ¤ 325.00 t7qu6FpkD7H2sjjhNBV+MTGC9n4ry+I9w1tgNgW0rsU=-~hlIPoU6hFn2lRxgfbHqhyA==
T-11 Internship Search Boykin Dimitri PUB-104 Job Search 4 ¤ 400.00 sr7to98XDMbuBMej4Jh1H2ikcpdCWwYeFsrmdA0kQnQ=-~26U2CmXnQVEuhUb3r2/JPw==
T-12 Professional-Level Job Search Ortiz Ricardo PUB-105 Job Search 6 ¤ 300.00 KMX176Jxs83d7sAYKWmadzNDo90YeF8xGi3w0VBGzOk=-~tDwGar2iq4Tx1bEQnzDnBg==
T-13 The Best Use of a Cover Letter Burke Kay PUB-106 Job Search 10 ¤ 325.00 Dk0wrLN9Ou1TOPG3FGtvMVUs7EbLV5j9YJ52dc0BHcQ=-~YAMQ+EVR7pIk0SywYwfqsw==
T-14 Finding Hiring Employers Blanchett Donald PUB-107 Job Search 7 ¤ 275.00 C86bEfDVTViOf1A0ARrKkP3i3n0GblitxjjC+gwb5Zo=-~aA+dtRotI1YPh92vQ1Yvhg==
T-15 New Dress for Success Gregerson Margo PUB-108 Interviewing Strategies 12 ¤ 525.00 X/OM4jCdNxk/n22u4c+uPJbE25+A9a/jWnmCdjDJQow=-~CfgT7vBEP2HgXig/3d9pOQ==
T-16 First Impressions Epstein Lonnie PUB-110 Interviewing Strategies 10 ¤ 420.00 Q2+9uyPaZ0qP/xE5lfdL+rYFAVy1LjaQ6zrJKj/Qm1c=-~kyhdj63Hdsdgm9LdMdLKlw==
T-17 Interview Techniques and Resume Tips Erwin Paulette PUB-109 Resumes 13 ¤ 525.00 ko2ULJwmNalkw12MnN1GKgt8Rv9L3uNaSIwwpjQAis8=-~VaAS5OqdtZ1kO0yUJsWgaw==
T-18 Resumes in Cyberspace Smith John PUB-107 Resumes 11 ¤ 420.00 OXsCZ5UrMVdPGRVn79+XekSF6X43RC8cGy3dtjk9OuE=-~AjXKFF20cnTm78R9t8B07A==
T-19 Mastering the Interview Jameson Susanna PUB-101 Interviewing Strategies 2 ¤ 125.00 6VA7z2snDCyV2msWk4F2AlsfNFx9zSY3djYI6p9C8cM=-~PfsEaE9nEyslKGAZWn19tA==
T-20 Smart Answers to Tough Questions Smith Gary PUB-100 Interviewing Strategies 1 ¤ 75.00 HPjsvZGS7DQFkBjfRGWWy9MMVt9+mIVjeh/noHX7vGk=-~O+/wPQrqkY2pgddtTpuYKA==
T-21 Job Winning Strategies Jones Janet PUB-100 Job Search 2 ¤ 250.00 1i3ug/s9nfC8/L9FjFIAPUR0Z/OABSQRwztKn7250po=-~VrWc12q2j0eIwdBSc7zaVw==
T-22 Jobs of the Future Greene Sharon PUB-104 Job Search 3 ¤ 325.00 aUe2ANi/1NrwY6vJOjxhAwwgI5RMd2s7HoLLc1nbMUY=-~jstEhzz2I4PaWQ4C30hPoQ==
T-23 Ace the Technical Interview Woo Paul PUB-104 Interviewing Strategies 1 ¤ 125.00 6EVMFB/GpaL7VS2kFuZoIZvrh7DYhDqWYmmmm02NoFg=-~RBNfo0Tpls09F/eV8ICGEg==
T-24 Mastering the Job Market Khan Alexis PUB-102 Job Search 3 ¤ 400.00 HvVCkWbUGjTOXXptmC7qjmHJFpB23buwtI6HHGaEIVY=-~hAq7vw/yso0aehQeTZp3sw==
T-26 High Tech Jobs Peterson Karen PUB-103 Job Search 5 ¤ 300.00 KUfdAG5nqEjcdV6l22CSUiUaBItzygCQnhata16NEJA=-~SwGcdSpyeNyrU5h2FnYvFA==
ID mSysRowId
1 pnkwPDv2yKDpCptBUO/guXrH+yu4q02JR6KVOX/j0Mg=-~vhun67q+iWCTVpgi/cz73A==
Publisher ID Company Name Rep Last Name Rep First Name Job Title Phone Number mSysRowId
PUB-100 AAA Career Books Visyas Victoria Sales Representative (703) 555-0054 JhNbNYurHVo7nMg66/HC2tYBsayfgR9FM6SUysSYhAY=-~IRBSLdxJ7EbZBurSOd5OVw==
PUB-101 Career Consultants Inc King James Sales Associate (703) 555-0071 XW7Bp3SY4D5D25a1JeI2dp/u0ulfLwJD02m6XKiZH3w=-~Y8oxgWr5BsU6qf3+6LZUxQ==
PUB-102 Executive Press Associates Phelps Pauline Regional Manager (703) 555-0063 z0XCxg04hwAqxDE8CW96wBIcBG8XORTFQ5FM613cToY=-~IUXqNNh4vka9/rmASTNyTg==
PUB-103 Conner, Dunne, & Murphy Publishers Hernandez Hector Sales Representative (703) 555-0012 GpvY1a/d/r3BD+FDCrwSqCJNyiyd3gCfwlbWVjvSVpU=-~Mt7nk/NCeiIfmB8+HMZUjw==
PUB-104 Employment Central Ltd Mizumori Raymond Sales Representative (703) 555-0041 c8uadncNTVVVX1U3o85huermGX/3QPgRjTjF6N2IBLw=-~50mHDq1x8MTWawscQoshjA==
PUB-105 John Richmond & Sons Nguyen Timothy Sales Representative (703) 555-0051 BbtKb23nmJqrX+MutDI7sNNGAcEFz6p9jFwH84A4SAs=-~m1LmhT8WOlhnYa7bNIrhIw==
PUB-106 Woodward Publishers Lamb Anne Technical Sales Rep (703) 555-0065 7G4Lig7epYNV1Om1UUgyDxeleyew2qtB+tL5lFVMhpU=-~1Mskf94MzqC0vIe3g+pZJA==
PUB-107 Careers R Us Butler Benjamin Sales Associate (703) 555-0098 7M4bIdjZdySNnGBgvUicNrPjdm47YrH2U/V33gz2B1U=-~sMec/gm0ov0T+lM7SWOTeg==
PUB-108 Harrisonburg Publishing Soto Jacob Sales Associate (703) 555-0064 kC7q7qMP1jblH/cT2pH14B247vI30t2CaiPSGX5+ylU=-~8ixQ2IR/zgYF+XeoTBhwBw==
PUB-109 Monroe & Sons Inc Bryant Robert Sales Representative (703) 555-0063 mSUZbOfKSONvt97rjvzp/i+dw9Lvwvidxzqcnrf4l78=-~VKXsU+VZdjXthxmn5mkQwQ==
PUB-110 Brewster Benton of New York Molvik Sergei Sales Representative (703) 555-0072 VTuZYEHKmm1C/2iG5k5OGd0jCj6msY+XRFIzHIFTJv8=-~I+IIMaTf2Q7cUEaFNiTLbg==
