Courses / Access - Intermediate
Access - Intermediate
- Provider
- Desktop Training & Development Ltd
- Summary
- 1 day course aimed at those with some previous experience of Microsoft Access, held in Ipswich.
About the Course
- Target
- Delegates with some experience of Microsoft Access who can easily construct simple databases.
- Entry requirements
- Delegates should have attended the Introductory course or gained similar knowledge in the workplace
- Outcome
- To demonstrate Access' more powerful features, particularly queries and forms
- Content
- Querying Information in A Database
- creating a select query
- specifying criteria
- creating parameter queries
- adding calculated fields
- calculating totals in queries
- creating crosstab queries
- make table query
- delete query
- update query
- append query
Creating Multiple Table Queries- creating relationships
- outer & inner joins
- query properties
Creating Grouped Reports- sorting and grouping data
- creating a grouped report
- modifying a grouped report
- group headers and footers
- range and interval grouping ยท printing properties
- calculating totals
Working with Sub-Reports- combining two or more reports
- linking a main and sub-report
Form Design- editing controls
- calculated controls
- properties of controls
- sizing and aligning controls
- setting a forms properties
Customising Forms- adding combo and list boxes
- options for displaying yes/no values
- creating option groups
- adding command buttons
Main and Sub-Forms- creating a menu & sub-form
- linking the main and sub-form together
Creating Dialog Box Forms- creating a menu form
- using a form as a dialog box
- start up dialog box
General Topics- compacting and repairing a database
- creating an auto-lookup query
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- Please contact Desktop Training for further details
- Enrolment
- Telephone, fax or write to Destktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- Please contact Desktop Training for dates
- Duration
- 1 day
- Timetable
- 9:30-16:30
- 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
