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