{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Access Project - The purpose of this assignment is to help...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
The purpose of this assignment is to help you gain a basic understanding of both Access and database concepts. You are to create tables, forms, queries, and reports for a database that tracks earning for the employees of fictitious company that you create. Database Name: Create an Access database, using LastFirstname as its name. Then perform the following tasks within the database. Create four tables: tblEmployee, tblEarnings, tblDepartment and tblJobTitle with the following required attributes (fields). (Hint: Click the create menu, and then select “Tables Design” to create a new table.) tblDepartment: Create the following fields: Field Data type Length Validation rule/Remark DeptCode Text 2 (Primary Key) Department Text 50 tblJobTitle: Create the following fields: Field Data type Length Validation rule/Remark JobCode Text 2 (Primary Key) Job Title Text 50 tblEmployee: Create the following fields: Field Data Type Length Validation Rule/Remark CID Number (long integer) Primary Key Name (Last, First) Text House Number (long integer) Street Text 32 Block Number (long integer) City Text 50 DeptCode Text 2 Must Exist in tblDepartment JobCode Text 2 Must Exist in tblJobTitle PayRate Number (Double) <=100 tblEarnings: Create the following fields: Field Data Type Length Validation Rule RecordNo AutoNumber (Primary Key) Date Date/time CID Number (Long Integer) Must Exist in tblEmployee HourseWorked Number (Double) <=60
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}