Courses / Access - Advanced
Access - Advanced
- Provider
- Desktop Training & Development Ltd
- Summary
- 1 day course aimed at experienced users of Microsoft Access, held in Ipswich.
About the Course
- Target
- Delegates with reasonable experience of Access and who have designed a simple database
- Entry requirements
- Delegates should have attended the Intermediate course or gained similar knowledge in the workplace
- Outcome
- To demonstrate Access's powerful advanced features including macros, creating custom menus and toolbars and database administration
- Content
- Macros
- creating macros
- the macro design window
- saving and running a macro
- creating a macro group
- referring to control names
- using conditions
- debugging macros
- autoexec and autokeys macros
Using Macros in Forms- form events
- macros that respond to events
- setting values
- going to controls, pages, records
- filtering records
- finding a record
- displaying messages
- synchronising forms
Using Macros in Reports- report events
- highlighting data and sections
- totals in page headers and footers
Custom Toolbars and Menus- creating custom toolbars
- the customise dialog box
- changing a buttons appearance
- showing and hiding toolbars
- allowing use of built in toolbars
- creating custom menus
Using SQL in Access- using SQL to populate controls
- creating union queries
- creating subqueries
Securing Your Database- securing an application
- activating the logon password
- creating a workgroup
- adding users
- creating and managing groups
- assigning permissions
- changing passwords
- creating a shortcut to open a secured database
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- Contact Desktop Training for details
- Enrolment
- Telephone, fax or write to Destktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- Training dates are available on request
- Duration
- 1 day
- Timetable
- 9.30 am - 16.30 pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Courses
Syndicate
