Please enter a date range below to find available courses
From to
Provider: 1816
Access Learning CDs 2003 Advanced
Course aim
This course aims to develop skills using Microsoft Access to produce and databases to an Advanced level.
Course outline
The CD course covers:
Select Queries • Creating in Design View • Sorting • Adding Additional Tables • Changing Relationship Type • The Show Box Filtering with Criteria - Exact Entries - Comparison Operators - Filter Range • Null/Not Null • Using "And" Statements • Either "Or" Statements • Unique Values Calculations • Formulas • Group By • Concatenation Intro to Forms • Creating Auto Forms • Form Components • Working with Controls • Aligning Controls • Removing Controls • Adding Controls • Using the Forms Wizard
Working in Forms • Formatting Forms • Control Properties • Navigating a Form
Data Access Pages • Save Form As • Using the Page Wizard • Apply Themes • Preview in Browser
Working with Reports • Creating Auto Reports • Using the Reports Wizard • Report Controls & Sections • Modifying Controls • Changing Sorting & Grouping • Controlling Page Breaks • Report Output Options • Exporting to Word
Maintaining Database • Using Compact & Repair • Backing up Data • Convert Database