Description
Course Content
Screen Familiarity
Planning and Designing Databases
♦ Database Objective
♦ Scope Document
Planning and Designing Databases – Tables
♦ Review existing data sources
♦ Normalisation
♦ Field Types – Text, Number, Date, Yes/No, Memo and AutoNumber
♦ OLE & Hyperlink Field Types
♦ Identify Field Sizes
♦ Identify the Primary Key
♦ Identify Field Properties
♦ Define table relationships
Creating Tables
♦ Building and Modifying Tables
♦ Assigning the Primary Keys
♦ Identifying Foreign Keys
Field Properties – All
♦ Data Validation – including logical
♦ Lookup Wizard with Values
♦ Indexing
Testing tables with Data Entry
Table Relationships
♦ Create Relationships
♦ Enforce referential integrity
Planning and Designing Databases – Forms
♦ Form Considerations – Data Entry
♦ Form Considerations – Menu
♦ Proto Types
♦ Identify Data Sources
Building and Modifying Forms
♦ Create a form with the Form Wizard
♦ Use the Control Toolbox to add controls
♦ Moving and resizing Objects
♦ Modify Format Properties (font, style, font size, colour, caption, etc.) of controls
♦ Use form sections (headers, footers, and detail)
♦ Yes/No Alternatives
♦ Tab Order
♦ Enable and Locked Control
♦ Adding Pages/Tabs
♦ Adding Graphics to a Form
♦ Creating Subforms
Reports
♦ Create a Report with the Report Wizard
♦ Move and resize a control
♦ Modify Format Properties (font, style, font size, color, caption, etc.)
♦ Calculated Reports
♦ Use report sections (headers, footers, and detail) + Page Breaks
♦ Adding graphics to a Report
♦ Sort Options
♦ Sub-Reports
Using Access Tools
♦ Print Table Designs – Reporter
♦ Back-up and restore a database
♦ Compact A Database
♦ Repair a Database
Importing data from Excel and Text files
Course Duration: One Day