Reference no: EM132515474

Practice - Access

Problem 1: Table

1. Create a new database file "Access- Employee" then perform the following:

2. Create table with name "Employee" contains the following fields:
• E-ID: Number and make it as a Primary Key
• First Name: Short Text
• Last Name: Short Text
• Salary: Number
• Birth Date: Date/Time
• Department: Short Text
• Position: Short Text

3. Insert the first record in the table

Problem 2: Queries

Create the following Queries on employee table:

» Query that views all the information for the employee work at IT department. Save it as Query1.

» Query that views the fields (E-ID, First Name, Last Name and salary) for all employees their salary is greater than or equal 30000. Save it as Query2.
» Query that views the fields (E-ID, First Name, Last Name Department and Position) for all employees their Department is "IT" and their Position is "Manager". Save it as Query3.
» Query that views all the information for all employees whose birth date in 1970 or their position is officer. Save it as Query4.
» Query that views all the information for all employees their first name's start with letters M or A. save it as query 5.

Problem 2: Forms

» Tabular Form that views all employees' information based on employees table. Save it as your name.

» Justify Form based on Query4. Save it as Query4_form.

Problem 3: Reports

» A block report based on Employees table which views all information classified by department.

Show the sum salary for each department then save it as Employee.