In this project, you will apply skills you practiced from the objectives in Access Chapters 4-10....

Question

In this project, you will apply skills you practiced from the objectives in Access Chapters 4-10. You will update the current database for Frank Osei, the Vice President of Finance, as he manages the company’s growth. You will modify existing tables and create a new one to track part-time employee information. In addition, you will create queries to assist Frank as he monitors the company’s performance and requests that data be updated. You will also create forms and reports to display information from the current tables and queries and maintain the database.

Ali Asgar · Accepted Answer

Lastname_Firstname_BRC1_Inventory_Suppliers
	Empl ID	Jan  Hours	Feb  Hours	March  Hours
	CB241	0	20	25
	CL965	51	99	70
	DT642	83	79	85
	ED032	80	80	66
	LM308	127	118	122
	AppID	First Name	Last Name	Phone	Application Date	mSysRowId
	1	Lucy	Winters	5035552890	5/15/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	2	Zhenyu	Tang	9715554099	5/28/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	3	Parker	Gac	9715550088	6/10/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	4	Dean	Sontag	5035556701	6/21/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	5	Cynthia	Sorretano	5035557620	6/30/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	6	Jason	Mansfield	5035552369	7/11/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	7	Alyson	Jeters	9715557421	7/15/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	8	Su Lin	Jenson	5035555487	7/27/19	qGHRMn0oQ4Yft3ndNr8lnfl0jbPgywLnZ4qZsztUJ6M=-~0qIgJIf7TKh9QMtcCgmPOQ==
	Item ID	Item Name	Retail Price	Cost	Category	Sport	Supplier ID	Item Image
	106555	Snowboard	¤ 256.99	¤ 107.94	Equipment	Skiing	SUPP-06	
	106556	Wool Socks	¤ 12.59	¤ 5.29	Socks and Gloves	Skiing	SUPP-04	
	114564	Bite Rite	¤ 71.06	¤ 29.85	Shoes	Biking	SUPP-11	
	114568	Vented Explorer 	¤ 34.78	¤ 14.61	Hats	Hiking	SUPP-04	
	117895	Celerater	¤ 91.60	¤ 38.47	Shoes	Hiking	SUPP-01	
	145622	Tie Breaker	¤ 69.55	¤ 29.21	Tops and Tees	Fitness	SUPP-03	
	145689	Ultra Bibs	¤ 130.89	¤ 54.97	Shorts	Biking	SUPP-10	
	146553	K Face	¤ 179.95	¤ 75.

In this project, you will apply skills you practiced from the objectives in Access Chapters 4-10. You will update the current database for Frank Osei, the Vice President of Finance, as he manages the...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment