UJIAN KOMPUTER 2

Akhirnya berlangsung ujian komputer 2 yang juga merupakan ujian komputer akhir bagi Semester 1 ini, menglibatkan topik pembelajaran Mircosoft Access. Untuk perjumpaan kelas hari ini Dr. Norazlia Binti Mat turut bersama namun terbatas pergerakkan akibat kesihatan yang kurang baik, mungkin kesan daripada perubahan cuaca setibanya menunaikan ibadah umrah. Dan menyerahkan kepercayaan kepada pelajar-pelajar nya supaya menjawap soalan dengan tertib dan tidak membuat bising. Walaupun dengan ketiadaan Dr. Norazlia Binti Mat, ketika berlangsungnya ujian tersebut, di perhujung waktu, beliau akan kembali semula ke kelas.

Jadi ujian nya berlansung pada jam 9.00pagi dengan arahan seperti berikut:-

LAB TEST 2 – MICROSOFT ACCESS 

Develop a database for the company name (your matrix no, eg; A1234567). In the database create four files about the Employees, Departments, Job Titles and Employees Expenses. Then, made the necessary relationships between the files to produce queries, forms and report later.         

     1.In Employees File include the following information’s:

a.      Employee Id,

b.      Name

c.       H/P Number (Create Input Mask)

d.      Email

e.      Gender (Lookup wizard)

f.       DOB (Date of Birth)

g.      Status (lookup wizard)

h.      Their photo (put only 2 photo for 2 employees).

·        Give appropriate data types for each field.

·        Then create 16 records in this file.

      2.In Department File include the following information’s

a.      Department ID,

b.      Department Name, (EG: Human Resource, Financial & Accounting, Manufacturing & Information Technology) 

c.       Employee Id (select 4 employees for each department using lookup wizard),

d.      Phone number

e.      Fax Number

f.       Job Title

g.      Head of Department (Yes/No) (If job title manager, tick this data as yes, meaning the manager is the head of the department)

·        Give appropriate data types for each field.

·        Then create four department records in this file.

        3.In Job Title File include the following information’s

a.      Job Id,

b.      Job Title, (eg: Manager, Assistant Manager, Executive)

c.       Department Id,

d.      Basic Salary,

e.      Transport Allowance

f.       Living Allowance

g.      House Allowance

h.      Entertainment Allowance (Only for Manager) 

i.        Total Gross Income

·        Give appropriate data types for each field.

·        Then create two job titles for each department. Meaning record in this file are 8 records.

         4.In Employees Expenses file include the following information’s

a.      Employee Id,

b.      Job Title

c.       Total Gross Income (get from job title file)

d.      House Loan, (10% from gross income)

e.      Car Loan, (5% from gross income)

f.       KWSP (10% from basic pay)

g.      Others ((10% from gross income)

h.      Total Expenses

·        Give appropriate data types for each field.

·        Then create 16 records in this file.

          5.Create the relationship for all tables.(this being create when you do lookup wizard)

          6.Create 2 query :

a.      First Query: Contain information about –

Employees File	Department File	Job Title File
Employees Id	Department Name	Job Title
Their Name	Phone	Basic Salary.
Gender	Fax

·        Save query as Employees Info Query.

b.      Second Query: Contain information about –

Employees File	Department File	Job Title File	Employees Expenses
Employees Id	Department Name	Basic Salary	House Loan
Their Name	Job Title	Transport Allowance	Car Loan
Gender		Living Allowance	KWSP
Photo		House Allowance	Others
		Entertainment Allowance	Total Expenses
		Total Gross Income

Save query as Pay Slip Query.

           7.Using first query (Employee Info) create two report.

a.      First report group by gender.

b.      Second report group by department.

           8.Using second query, create a form name payslip.

a.      In the pay slip calculate

                                                   i.     Net income

                                                   ii.     Age

           9.Transfer the four main table into four form.

   

        10.Create a Navigation form with link to 2 reports and five forms and a button to link to Start Up page.

        11.Finally create a START UP page with company name, button (Enter and Exit) and logo on the page.

GOOD LUCK!!