ACCESS DATABASE

 Each individual should create an Access database that includes 2 different tables: an employee table and a customer table. Field titles for the employee table should be as follows: Employee ID number First name Last name Address Date of hire Date of birth Social security number Hourly wage Field titles for the customer table should be the following: Customer ID number First name Last name Address Phone number Number of items sold to store Select the appropriate data type for each field title (for example: social security number would be number type) For the employee table, enter 8 fake employees into the table For the customer table, enter 10 fake customers into the table Appropriately title each table If you think of other field titles that should be included, make sure to include them. Some things to consider: To create a new table, click "Create" on the top toolbar and then select table. To add field titles on the "Home" toolbar switch to Design View.

Answer Detail

Get This Answer

Invite Tutor