MS-Access 2007


 * Designing and building the database
 * Forms
 * Reports
 * Queries
 * Macros
 * Visual Basic
 * Answers

Flatfile database: Tasks

 * Tasks

Relational database: Library

 * Design System Analysis:Library

Relational database: Sales, Hire and Repair Company
Design


 * System Analysis:Sale/Hire/Repair Company

Create the database, Entities(tables) and Attributes(Fields)


 * Enterprise database
 * Human Resource tables (Staff, Timesheet)
 * Accounts tables (Client, Transaction)
 * Hire tables (Client, Equipment, Hire)
 * Stock tables
 * Repair tables

Sub systems


 * Human Resources (1-many)
 * Add data, documenter, ERD report
 * Staff (single table)
 * Form
 * Report-Phone list
 * Report-Masterfile
 * Staff x Timesheet (1 to many)
 * Forms and sub-forms
 * Multi-table report
 * Linking a report to a form


 * Access07: Hire Co : Accounts


 * Hire (many-many)
 * Query : Hire x Equipment
 * Hire form


 * Access07: Hire Co : Stock


 * Access07: Hire Co : Repair

Help Desk

 * Help Desk