Courses / Microsoft Access - Advanced
Microsoft Access - Advanced
- Provider
- Desktop Training & Development Ltd
- Summary
- 1 day course aimed at experience 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
- Good working knowledge of Access is esential.
- 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 � designating a global menu bar 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
- Cost
- Please contact provider for further details.
- Enrolment
- Telephone, fax or write to Destktop.
Availability
- Starts
- Courses arranged throughout the year, at provider's own premises. Private or Closed courses arranged on request.
- Duration
- 1 day
- Timetable
- 9.30 am - 16.30 pm
- Provider
- Desktop Training & Development Ltd
Venues
Main
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
