Managing the Challenge of Constant Change

Text Box: Custom databases - other topics

The Employee Database

 

· Manages all aspects of employee management

· Reporting  to Dept. of Labour (SA) standards

· Employee equity calculations

· Annual appraisals

· Linked to salary database

· Produces ’swipe’ security cards

· Issues employee contracts

Import & Export tracking

 

· Product imported to several locations

· Product exported to several countries

· All related transactions on one screen

· All statuses of shipment tracked

· Full inventory reporting

· Margin analysis

· Fields colour coded to show outstanding entries

Preparation of form above is a task for students taking the

MS Access Fundamentals course

To Page 2 Custom databases