Microsoft Access VBA
DURATION
1 days
LOCATION
Exeter or onsite at your premises.
For onsite courses we can provide the rental of laptops with the software pre-installed.
PREREQUISITES
Delegates should have attended the Introduction to Windows course or be proficient in the use of a personal computer using the Windows operating system.
COURSE OUTLINE
Delegates will learn advanced database concepts including how to use forms, reports & query advanced features and how to exchange data. This course is designed to give you a further understanding of the features and functions available in Access to a level of competence sufficient for participants to produce more sophisticated database application; to be able to create a variety of data views, queries and reports including cross-tabs; and to automate their application through the use of menus, macros and buttons.
SUBJECT AREAS (PLEASE NOTE, SUBJECT AREAS COVERED WILL DEPEND ON DELEGATES ABILITY AND TIME AVAILABLE)
FORM CUSTOMISATION
- Linking a form to a table
- Placing controls on the form
- Aligning controls on a form
- Sizing to fit controls on a form
- Special effects
- Setting tab order
- Placing a bound control on the form
- Placing a check box on the form
- Placing a command button on the form
- Placing a group box on the form
- Placing a combo box on the form
- Placing a list box on the form
TYPES OF FORMS
- Popup forms
- Modal forms
- Split forms
LIMITING USER ACCESS
- Limiting users from adding new records
- Limiting users from deleting existing records
- Limiting users from editing a records
EXPORTING FORM TO XML
- Exporting to XML
REPORTS
- Creating a report
- Creating an AutoFormat template
- Applying an AutoFormat to a report using the Report
WIZARD
- Applying an AutoFormat to an existing report
- Conditional formatting
- Subreports
- Formatting reports
ACCESS SWITCHBOARDS
- What is a switchboard?
- Creating a Switchboard
- Adding a switchboard
- Deleting a switchboard
- Adding items to a Switchboard
- Editing a Switchboard
- Deleting items within a Switchboard
- Editing items within a Switchboard
- Making a Switchboard the default Switchboard
- Displaying Switchboards automatically when opening
a database
CUSTOMISING ACCESS
- Access customisation options
- Current Database options
- Datasheet options
- Object Designers options
- Proofing options
- Customize options
- Add-ins options
TO BOOK
For more information or to book onto our Microsoft Access VBA training course please contact us on 01392 824 022 or email training@amesolutions.co.uk.
If there is a Microsoft course that is not listed on our site, that you are interested in attending then please let us know and we can arrange one to one training onsite with our Trainer.
You can see a full list of our training courses here.
Still not convinced?
We can help you!
Fill out the form below and one of our IT specialists will contact you.