The Wedgewood Pacific Corporation (WPC), founded in 1957 in Seattle, Washington, has grown...

The Wedgewood Pacific Corporation (WPC), founded in 1957 in Seattle, Washington, has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The company database contains data about employees; departments; projects; assets, such as computer equipment; and other aspects of company operations.

A. Create a Microsoft Access database named WPC in a Microsoft Access file named WPC.accdb.

---

B. Figure 1 shows the column characteristics for the WPC EMPLOYEE table. Using the column characteristics, create the EMPLOYEE table in the WPC database.

Figure 1 Database Column Characteristics for the EMPLOYEE Table

Figure 1

---

C. Figure 2 shows the data for the WPC EMPLOYEE table. Using Datasheet view, enter the data for the first three rows of data in the EMPLOYEE table shown in Figure 2 into your EMPLOYEE table.

---

Figure 2 Wedgewood Pacific Corporation EMPLOYEE Data

Figure 2

---

D. Create a data input form for the EMPLOYEE table and name it WPC 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 2 into your EMPLOYEE table.

Figure Wedgewood Pacific Corporation EMPLOYEE Data

Figure 2

---

E. Create a report named Wedgewood Pacific Corporation 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.