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’ dat

Assignment 1 (Section A): Database

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.

Task 1

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.

1. Use the proper table specifications, including the given table names, field names, and primary keys.
2. Select the appropriate data type for each field from the following:

• Text, number, Date/Time, Currency, Yes/No, and etc.

3. Ensure that you also ‘set’ properties for each field where appropriate. You must set the following:

• Field size, Field Description, Caption, and other relevant properties.

4. You may also consider setting the following:

• Format, Decimals, Default Value, Validation Rule, and Validation Text.

Task 2

Create relationships between the tables.

Task 3                                                                         

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.

Task 4

Create any five different queries in Microsoft Access.

Task 5

Using the Report Wizard, create five reports that produce a professional-looking based on the five different queries.