Question: . 6-Project Requirements: Students will research and gather data about one of the following projects: 1. Online retail application database 2. Railway system database 3.

. 6-Project Requirements: Students will research and gather data about one of the following projects: 1. Online retail application database 2. Railway system database 3. Hospital management system database 4. Library management system database 5. Restaurant management database 6. Art gallery management database 7. Hotel management system database 8. Wholesale management system database They will create an Excel spreadsheet for compiling business information. Task A - Business: Contact Information keyed in Excel By using Ms. Office Excel create two worksheets to compile the data, you gathered about the business. One sheet should include department details "minimum four departments" such as Department ID, Name, size, etc... minimum six columns. The other sheet should include the employees' details, "minimum 10 Employees" such as Employee ID, Name, Phone number, email address, job title, salary, hiring date, etc..... minimum six columns. [5 Marks] Task B - Import Excel spreadsheet Content Import Excel spreadsheets with business details into a new Access database. Name the new tables Department Details and Employees Details. Assign a primary key for each table and create an appropriate relationship among those two tables. [5 Marks] Task C - Access Database This task will vary from one group to another based on the business category that they choose. Each group should create a minimum of one additional table to record their items, such as products or services this business provides. The table should include all field names with proper data types and the appropriate primary key. Examples of business categories and types of tables: Online retail application: Products, services, menu, offers, etc. Railway system: trains, schedule, routes, etc. Hospital: doctor schedule, clinic, drug suppliers, etc. Library: books, loans, articles, registered clients, etc. Restaurant menus, suppliers, clients, items, inventory, etc. Art gallery: items, maintenance, suppliers, etc. Hotel: rooms, services, bills, reservations, etc. Wholesale: products, suppliers, offers, etc. [6 Mark] Task D - Creating Queries, Forms, and Reports Create forms based on the tables you created for data entry purposes "one form for each table" (total of three forms). Create several queries "minimum three" with different criteria as per your business needs. Create several reports "minimum three" with different data combinations as per your business needs
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
