Courses / Access Advanced
Access Advanced
- Provider
- Corazon Training
- Summary
- 1 day course covering all aspects of database entry and operation.
About the Course
- Target
- Those who have a reasonable understanding of Microsoft's database application, Access.
- Entry requirements
- A good knowledge of working in the Windows environment essential
- Outcome
- Participants will improve their knowledge of Access
- Content
- Custom Formatting
- Custom Number Format
- Custom Date Format Codes
- Using Conditional Formats
Working with Named Ranges- Creating Range Names
- Using the Go To Command
- Range Names in calculations
Importing and Exporting Data- Object Linking and Embedding
- Sharing Data with Other Applications
- Importing a Text File into Excel
Lookups and Data Tables- Creating Data Tables
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Preventing LOOKUP Errors
Templates- Creating Workbook Templates
- Custom Templates
- Storing Templates
Analytical Tools- Using Goal Seek and Solver
- Working with Scenarios
- Using Views
Using Pivot Tables- Creating Pivot Tables
- Formatting Pivot Tables
- Rearranging Pivot Tables
- Working with Pivot Charts
Using Views and Creating Reports- Creating Custom Views
- Creating a Workspace File
- Using Workspace Files
- Using the Report Manager
- Printing Reports
Using Macros- Understanding Macros
- Recording a Basic Macro
- Running a Macro
- Assigning a Macro to a Toolbar
- Button Image Editor
- Editing a Macro
- Macro Virus Protection
- Custom Number Format
- Cost
- Training rates are available on request
- Enrolment
- .
- Website
- www.corazonit.com
Availability
- Starts
- All training is delivered on clients site and can be either one to one or in groups.
- Duration
- 1 day course
- Timetable
- By mutual agreement
- Provider
- Corazon Training
Venues/Contact
Main (View map)
146 Woodbridge Road
IPSWICH
Suffolk
IP4 2NS
UNITED KINGDOM
Telephone 01473 219593 m: 07702911223
Fax 01473 219593
Email info@corazonit.com
Website http://www.corazonIT.com
Venue Notes At Client's site:
Contact Elene Marsden
Courses
Syndicate
