A.K.Solutions:- Microsoft Access Part 3

Microsoft Access
Forms and Reports

Tel:
024 7637 2073

To return to the Microsoft Access Course Index please Click Here

A.K.Solutions: Microsoft Access Forms and Reports Course Content
This 2 day course begins with simple form design techniques covering topics such as 'What is a form control'? to more advanced features on how to trigger event handling and using snippets of VBA code. The 2nd day leads into the similarities in report design to form design and then explains how to Group / Sort and Total data within a report. By the end of the course a candidate should feel more confident in the design of both Forms and Reports enabling them to give that 'professional' touch to an Access database.

Creating forms
- Use of the wizards to create a variety of form designs
- Creating forms without the wizard
- Understanding the different Sections within a form
- Use of a form as a menu
- Use of Headers and Footers
- Placing a Sub Form within another form
Form Controls
- What are form controls?
- How to change a controls properties
- Repositioning controls
- Aligning / Resizing controls
- Enabling / Disabling controls
- Creating a 'calculated control'
- Changing the Tab Order in form design mode
- Changing Tab Order during data entry
- Hiding controls
- Flashing controls
Event handling
- Examine the 'Before Update' and 'After Update' events
- Using 'Before Update' event to validate data
- Using the 'Cancel' argument of a 'Before Update' event
- Use of the 'After Update' event to trigger other events
- Use of the 'On Click' event
- Using snippets of VBA code with the event handler
- Using command buttons on forms to execute VBA
- Creating bespoke command buttons
- Modifying table field values using VBA
Tables and Queries
- Using a Table as a form or reports data source
- Using a query to Filter data for a form or report
- Using a query to select records from multiple tables
- Modifying the Order of records displayed in a form
Report Design
- Using wizard to create a variety of report designs
- Modifying a reports design
- Similarities in report design to form design
- The different sections of the report
- Grouping / Sorting / Totaling records
- Group headers and footers
- Using a Macro to run a report
- Displaying a report in 'Print Preview' mode
- Placing dynamic function in a report control to count records
- Adding report to a main menu

You may print this page by selecting File Print in your Browser Window

Before taking this course.
All candidates are advised to have a good working knowledge of Microsoft Access.

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

E-Mail Us

Tel:
024 7637 2073