Microsoft Access Intermediate (2007, 2010 & 2013)
Course
Online
Description
-
Type
Course
-
Methodology
Online
Duration This is a one-day training course structured into 5 modules Target Audience Users with a basic understanding of Microsoft Office Access 2007, 2010 or 2013 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course. Class Sizes Maximum class size for Microsoft Access courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates. Learning Objectives This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts for Access 2007, 2010 and 2013 in order to increase their knowledge and productivity.
About this course
Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Reviews
Subjects
- Microsoft Access
- Access
Course programme
MODULE 1: Advanced File Tasks
Learning outcomes:
A look at some important administrative features necessary for managing an Access Database file.
Topics covered:
- Using Windows Explorer within Access
- Database Management
- Saving Your Files
- Exporting Files
- Linking Files
MODULE 2: Working with Tables
Learning outcomes:
Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.
Topics covered:
- Customising Tables
- Table Properties: Formatting
- More Table Properties
- Data Validation and Lookup Wizard
MODULE 3: Working with Forms
Learning outcomes:
Building professional forms to enhance the user experience and improve effective use.
Topics covered:
- Basic Form Controls
- Advanced Form Controls
- Formatting Your Form
- Formatting Controls
- Using Themes
MODULE 4: Working with Reports
Learning outcomes:
Organise and format your reports professionally and common report tasks you may need to perform.
Topics covered:
- Organizing Report Data
- Formatting Reports
- Common Report Tasks
MODULE 5: Working with Queries
Learning outcomes:
Creating a range of different queries from very basic queries through to management queries with advanced functionality.
Topics covered:
- Basic Queries
- Doing More with Queries
- Creating Advanced Queries
- Creating Management (Action) Queries
Microsoft Access Intermediate (2007, 2010 & 2013)