Select a list of employees with a minimum of $10$ members consisting of employeeID, FirstName, LastName, HomeAddress, OfficePhone, Salary, Department, and Title based on your choice and call it EmployeesTable.

A$.$ Create another table and call it InvoicesTable which consists of

InvoiceNumber, Date, and MethodofPayment $($limit it to $3$ options$)?$

B$.$ Create another table and call it CustomersTable which includes CustomerID, Name, BillingAddress, and CreditCard?

C$.$ Create another table and call it ProductsTable which includes ProductID, ProductType, Size, Weight, Description, Price, and Manufacturer. All the tables must have a minimum of $10$ rows of data?

We want to relate the EmployeesTable to InvoicesTable. InvoicesTable to CustomesTable and CustomerTable to ProductsTable.

$1.$ Create tables and set up relationships using Microsoft Access. Assign a primary key for each table. Make EmployeeID, InvoiceID, and ProductID auto so that the system will auto$-$generate for every row of data that you add in the future. Show the relationship between tables?

$2.$ Create a query and calculate the Total price of items in that table.

Total price is $[$Quantity$]*[$item price$]?$