Question

Part 1 - Create tblJobs Table Review the page on Entities & Attributes for more information on design. 1. Start Access can create a new blank database then create a table named tblJobs name. 3. Add the following fields. Job Title o Hourly Pay field must be able to contain fractional dollar amounts: example 10.75 o Hours - field contains the weekly number of hours each job is scheduled, must be able to contain fractional hours typically between 20 to 40: example: 23.5 4. Add at least 2 more fields which are relevant to the job, give them appropriate field names. You should have a minimum of 6 fields in the table. Set the correct data type size for each field where the size is the set to the largest expected data attribute and type is set to match the data to be input. 5. 6. Enter a description for each field to explain what it is used for.

Answer 1

Part 1)

The table tblJobs is created in Access database. Database employee is used for creatting this table.

For creating table-

1. Go to Create tab

2. Go to Table Design

Table design wizard will get open.

Enter the values as shown in the screenshot

Once you save it table tblJobs get created.

tblJobs Field Name Data Type Description (Optional) JoblD JobTitle HourlyPay Hours Department MinExp AutoNumber Short Text Currency Number Short Text Number Stores the auto incremented Unique job ID's Stores the uniques Job title associated with each JonID Hourly pay associated with each job Hours required with each job The department to which that particular Job ID belongs to Minimum experience required for this job ID

Part 2)

For inserting the values in the table, double click the table name and insert values wiward get open. Insert the required values as shown in the screenshot.

The data inserted into the table.

tblJobs JoblD JobTitle HourlyPayHours Department MinExpCli Owner 2 Manager 3 Clerk 4 Accountant 5 Trainee R49.50 35.10 25.56 22.20 15.25 48 Self 30 Manufacturing 28 Back Office 22 Back Office 20 Manufacturing 0 10 0 New) 0 0