Question
Create Microsoft Access database based off the following: A. Create a Microsoft Access database named WP in a Microsoft Access file named WP.accdb. B. Figure
Create Microsoft Access database based off the following:
A. Create a Microsoft Access database named WP in a Microsoft Access file named WP.accdb. B. Figure 1-36 shows the column characteristics for the WP EMPLOYEE table. Using the column characteristics, create the EMPLOYEE table in the WP database. C. Figure 1-37 shows the data for the WP EMPLOYEE table. Using Datasheet view, enter the data for the first three rows of data in the EMPLOYEE table shown in Figure 1-37 into your EMPLOYEE table. D. Create a data input form for the EMPLOYEE table and name it WP Employee Data Form. Make any adjustments necessary to the form so that all data display properly. Use this form to enter the rest of the data in the EMPLOYEE table shown in Figure 1-37 into your EMPLOYEE table. E. Create a report named Wedgewood Pacific Employee Report that presents the data contained in your EMPLOYEE table sorted first by employee last name and second by employee first name. Make any adjustments necessary to the report so that all headings and data display properly. Print a copy of this report.
FIGURE 1-36 Database Column Characteristics for the WP EMPLOYEE Table EMPLOYEE Column Name Required Remarks Type Key EmployeeNumber AutoNumber Primary Key Yes Surrogate Key Short Text (25) FirstName No Yes LastName Short Text (25) No Yes Short Text (35) Department No Yes Short Text (35) No Position No Number Supervisor No No Long Integer OfficePhone Short Text (12) No No EmailAddress Short Text (100) No Yes FIGURE 1-37 Wedgewood Pacific EMPLOYEE Data FirstName LastName Department Position Super- OfficePhone EmailAddress Employee Number visor Jacobs Jackson Mary Administration CEO 360-285-8110 Mary.Jacobs@WP.com 360-285-8120 Rosalic.Jackson@WP.com Rosalie Administration Admin 1 Assistant Bandalone Legal Attorney 1 360-285-8210 Richard.Bandalone@WP.com Richard Smith George Human HR3 360-285-8310 George.Smith@WP.com 4 Resources Alan Adams Human HR1 360-285-8320 Alan.Adams@WP.com 4 Resources Evans Finance CFO Ken 360-285-8410 Ken.Evans@WP.com 360-285-8420 Mary.Abernathy@WP.com Mary Abernathy Finance Caruthers Accounting FA3 Tom FA2 360-285-8430 Tom.Caruthers@WP.com Jones Heather FA2 360-285-8440 Heathet.Jones@WP.com Accounting Sales and Marketing Sales and Marketing InfoSystems InfoSystems Ken Numoto SM3 360-285-8510 Ken.Numoto@WP.com 10 Granger 360-285-8520 Linda.Granger@WP.com Linda SM2 11 10 James Rick Nestor CIO 360-285-8610 James.Nestor@WP.com 12 Brown Rick.Brown@WP.com IS2 13 12 Mike Nguyen Research and CTO 360-285-8710 Mike.Nguyen@WP.com 14 Development Jason Sleeman Rescarch and RD3 360-285-8720 Jason.Sleeman@WP.com 15 14 Development Smith 360-285-8810 Mary.Smith@WP.com 360-285-8820 Tom,.Jackson@WP.com 360-285-8830 George.Jones@WP.com Julia.Hayakawa@WP.com Sam.Stewart@WP.com 16 Mary Production OPS3 OPS2 Tom Jackson Jones Hayakawa Production Production 16 17 George Julia Production OPS2 18 17 OPS1 19 17 Sam Stewart Production OPS1 17 FIGURE 1-36 Database Column Characteristics for the WP EMPLOYEE Table EMPLOYEE Column Name Required Remarks Type Key EmployeeNumber AutoNumber Primary Key Yes Surrogate Key Short Text (25) FirstName No Yes LastName Short Text (25) No Yes Short Text (35) Department No Yes Short Text (35) No Position No Number Supervisor No No Long Integer OfficePhone Short Text (12) No No EmailAddress Short Text (100) No Yes FIGURE 1-37 Wedgewood Pacific EMPLOYEE Data FirstName LastName Department Position Super- OfficePhone EmailAddress Employee Number visor Jacobs Jackson Mary Administration CEO 360-285-8110 Mary.Jacobs@WP.com 360-285-8120 Rosalic.Jackson@WP.com Rosalie Administration Admin 1 Assistant Bandalone Legal Attorney 1 360-285-8210 Richard.Bandalone@WP.com Richard Smith George Human HR3 360-285-8310 George.Smith@WP.com 4 Resources Alan Adams Human HR1 360-285-8320 Alan.Adams@WP.com 4 Resources Evans Finance CFO Ken 360-285-8410 Ken.Evans@WP.com 360-285-8420 Mary.Abernathy@WP.com Mary Abernathy Finance Caruthers Accounting FA3 Tom FA2 360-285-8430 Tom.Caruthers@WP.com Jones Heather FA2 360-285-8440 Heathet.Jones@WP.com Accounting Sales and Marketing Sales and Marketing InfoSystems InfoSystems Ken Numoto SM3 360-285-8510 Ken.Numoto@WP.com 10 Granger 360-285-8520 Linda.Granger@WP.com Linda SM2 11 10 James Rick Nestor CIO 360-285-8610 James.Nestor@WP.com 12 Brown Rick.Brown@WP.com IS2 13 12 Mike Nguyen Research and CTO 360-285-8710 Mike.Nguyen@WP.com 14 Development Jason Sleeman Rescarch and RD3 360-285-8720 Jason.Sleeman@WP.com 15 14 Development Smith 360-285-8810 Mary.Smith@WP.com 360-285-8820 Tom,.Jackson@WP.com 360-285-8830 George.Jones@WP.com Julia.Hayakawa@WP.com Sam.Stewart@WP.com 16 Mary Production OPS3 OPS2 Tom Jackson Jones Hayakawa Production Production 16 17 George Julia Production OPS2 18 17 OPS1 19 17 Sam Stewart Production OPS1 17Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started