Course Outline:
- Databases Explained
- What Is A Relational Database
- Components of Access Databases
- Getting Help
- Structuring & Designing A Database
- Creating Tables & Setting Data Types
- Setting Field Properties in Tables
- Primary & Foreign Keys
- Data Entry & AutoCorrect
- Modifying a Table Design
- Setting Up Relationships
- Using the Lookup Wizard
- Formatting Data in Tables
- Searching, Sorting & Filtering Data
- Creating & Using Select Queries
- Using Criteria in Queries
- Summarising Data with Queries
- Designing Data Entry Forms
- Using AutoForms & the Form Wizard
- Creating & Using Main Forms & Sub Forms
- The Form Design Work Surface & Toolbox Toolbar
- Modifying Forms
- Using AutoReports & the Report Wizard
- Modifying Report Design
- Generating Mailing Labels
- Printing in Access
The user will become conversant with all the fundamental features and functions of Access. The course incorporates an introduction to database theory and practice, plus hints & tips on good database design techniques.
|