Your firm’s system analyst has developed a database structure that has been determined to be suitable to create a database to store BROOM car accessories’ customers, products, orders, orders details, and employees’ data for the business.
Create a database and name it ‘Assign_1_SectionA.mdb’ then create the five tables (customers, products, orders, orders details, and employees)with the right table/ data specification in Microsoft Access using Table Design view.
Create relationships between the tables.
Create four professional forms based on the tables and enter at least30 sample data for testing. Include all tools available from form design such as combo box, command button, and other relevant tools.
Create any five different queries in Microsoft Access.
Using the Report Wizard, create five reports that produce a professional-looking based on the five different queries.