Email the course tutor or telephone 0116 232 5166 for more information.

FD12 – Microsoft® Access – Intermediate

Using Microsoft® Access this course is suitable if you are already able to use the functions covered in the introductory course or have a basic knowledge of Microsoft® Access. Please specify version required.

Email the course tutor or telephone 0116 232 5166 for more information.

FD13 – Microsoft® Access – Advanced

Using Microsoft® Access this course is suitable if you are already familiar with the functions covered in the introductory and intermediate courses. Please specify version required.

Topics include:

Introduction. Compacting Sample Databases. Forms and Subforms. Form Views. Checking Form Designs and Opening Property Sheets. Changing Design to Continuous Forms or Datasheet View. Creating Subforms. Navigating and Editing the Main Forms and the Subforms. Adding Data to a Form with Subforms. Using the Form and Subform Wizard. Linking a Different Subform. Adding Expressions. Using the Expression Builder. Calculating Totals in a Subform. Displaying Totals in the Main Form. Adding New Transaction Records. Creating Calculations in Queries. Parameter Queries. Crosstab Queries. Creating Append and Delete Queries. Removing Duplicate Records. Using Aggregate Functions with Calculated Fields. Using Dates in a Query. Using Wildcards. Using Several Parameters. Backing up Tables. Creating Reports. Report Design. Grouping and Sorting. Adding Pictures. Using Expressions in Reports. Creating Running Totals. Adding a Bound Text Box. Autofitting Labels. Parameters in Reports. Creating a Subreport. Creating Command Buttons. Creating a Print Labels Button. Events and Macros. Creating and Running a Macro. Using a Macro to Update Fields. The AutoExec Macro. The Verification Macro. Conditional Macros. MailMerge. Linking a Database Table to an Existing Document. Entering Merge Fields. Merging to a Printer. Changing and Editing the Data Source. Merge Options in Word.