Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you please answer A through E Exercises The Wedgewood Pacific (WP) company, founded in 1987 in Seattle, Washington, manufactures and sells consumer drone aircraft.
can you please answer A through E
Exercises The Wedgewood Pacific (WP) company, founded in 1987 in Seattle, Washington, manufactures and sells consumer drone aircraft. This is an innovative and rapidly developing market. In January 2018, the FAA said that 181,000 drones fout of the approximately 700,000 drones that may have been sold during the 2015 Christmas season) had been registered under the new FAA drone registration rules. 14 WP currently produces three drone models: the Alpha III, the Bravo III, and the Delta IV. These products are created by WP's Research and Development group, and produced at WP's production facilities. WP manufactures some of the parts used in the drones, but also purchases some parts from other suppliers. The company is located in two buildings. One building houses the Administration, Legal, Finance, Accounting, Human Resources, and Sales and Marketing departments, and the second houses the Information Systems, Research and Development, and Production departments. The company database contains data about employees; departments; projects; assets, such as finished goods inventory, parts inventory, and computer equipment; and other aspects of company operations. 2019). FICURE 1-37 Database Column Characterisfics for the WP EMPLOYEE Table EMPLOYEE \begin{tabular}{lllll} \hline Column Name & Type & Key & Required & Remarks \\ \hline EmployeeNumber & AutoNumber & Primary Key & Yo & Surrogate Key \\ FintName & Short Teat (25) & No & Yos \\ LastName & Shert Text (25) & No & Yos \\ Department & Short Text (35) & No & Yes \\ Ponition & Short Text (35) & No & No \\ Supervisor & Number & No & No \\ OfficePhone & Short Teat (12) & No & No \\ EmailAddress & Short Text (100) & No & Yos \\ \hline \end{tabular} FIGURE 1-38 Wedgewood Pacific EMPLOYEE Data A. Create a Microsoft Access database named WP in a Microsoft Access file named WP.acedb. B. Figure 1-37 shows the column characteristics for the WP EMPLOYEE table. Using the column characteristics, create the EMPLOYEE table in the WP database. C. Figure 1-38 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-38 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-38 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 Step 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