Task

Compare the figures - The following differences are evident;

1. The "CustomerID" in the main form is replaced by "Customer Name".

2. The "employee ID" in the main form is replaced by "Employee Name".

3. The look and feel of the form.

Information Systems Design and Development for Accountants

Database Name

6 tables created (tblEmployee, tblCard, tblCustomer, tblSaleHeader, tblLineItem, tblTimeSheet) 6X

Table Name, Primary key, field names, field properties

5 relationships established

Data Entry

Minimum requirements met and data realistic.
Challenge task

Update customer form created

Update project form created.

Challenge task

Sales data entry form created

Sales data entry form looks like Figure 40 in the write-up.

Customer Invoice form created

Challenge task

Timesheet Entry form created.

Payslip form created

Navigation form created, tabs linked to appropriate forms.

Attachment:- Access.rar