Introduction to Microsoft Access Course
Course Duration:
Two Days
Our introduction to Microsoft Access training course is suitable for complete beginners to Microsoft Access. At the end of this training course you will have a good working knowledge of Microsoft Access basics. You will feel more confident using Microsoft Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and create reports. Those who complete the Introduction to Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course.
Read on for further information on the Introduction to Microsoft Access training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page
Course Level:
Introduction
Course Requirements:
A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of Access is required.
Course Content:
Introduction
• What is a database?
• Relational databases
• Definitions of terms used
• Planning a database
• Identify reasons to build a relational database
Overview of Access
• Starting & Exiting Access
• Access Screen Layout & Toolbars
• Accessing Help
Creating A New Database
• Creating a Table
• Customising Data Entry
• Data Types and Formats
• Setting Primary Keys
• Setting Field Properties
• Add/Edit Fields
• Saving Tables
• Entering /Editing/Deleting Data
• Understand different type of relationship
• Set relationships between tables
Creating Forms
• Autoform
• Form Wizard
• Columnar Form
• Tabular Form
• Entering Data in a Form
• Modifying a Form
• Create a sub form
Queries
• Creating a query
• Sort Fields in a query
• Set up criteria for query
• Used expressions within the query
• Multi Table queries
• Concatenation and Calculation
• Parameter queries
• Change query join types
Reports
• Create Reports
• Print Reports
Useful For:
Availability:
Our Experience:
Intermediate Microsoft Access Course
Course Duration:
One Day
Our Intermediate Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. This computer training course is designed for those users who wish to step their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will understand relational databases and be able to work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Pivot Charts and PivotTables. Those who complete the Intermediate Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course
Read on for further information on the Intermediate Microsoft Access training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page
Course Level:
Intermediate
Course Requirements:
A basic working knowledge of Access is required, or completion of our Access Introduction course.
Course Content:
Tables
• Tables Refresher
• Importing/Exporting Data
• Relationships & Referential Integrity
• Primary & Foreign Keys
Queries
• Queries refresher
• Multi-Table Queries
• Action Queries
• Group By Queries
• Modifying Query Output
• Using Calculations & Expressions
Reports
• Using Report Wizard
• Tailoring Design of Reports
• Basing Reports on a Query
• Mailing Labels
Forms
• Using Form Wizard
• Tailoring Design of Forms
• Controls • Changing Tab Order
Useful For:
Availability:
Our Experience:
Advanced Microsoft Access Course
Course Duration:
One Day
Introduction:
Our Advanced Microsoft Access training course is suitable for those with a sound working knowledge of Microsoft Access who wish to progress to the most complicated functions and features.
At the end of this computer training course you will have a complete understanding of the higher functions of Microsoft Access. You will learn to automate functions by creating simple and then very advanced macros. You will advance your querying ability and then to use SQL statements in your queries. You will discover how to work with objects, and the fundamentals of database management. Finally you will be taught how to protect your valuable data sources. Those who complete the Advanced Microsoft Access course satisfactorily will receive a certificate at the end of the computer training course
Read on for further information on the Advanced Microsoft Access training course. For more information on our computer course trainers, and computer training course content and fees visit this computer training courses information page
Course Level:
Advanced
Course Requirements:
A working knowledge of Access or our Access Intermediate course
Course Content:
Review of Access Database Principles
Performance and Database Design
• Designing a Relational Database
• Normalisation of Data
• Primary and Secondary Keys
Queries
• Calculating in Queries
• Summary Queries
Forms
• Advances Form features
• Forms and Subforms
• Calculated fields
• Command buttons
• Bound and Unbound Controls
Reports
• Grouping data in reports
• Creating Calculations
Macros
• Creating Macros
• Adding Macros to command buttons
• Event driven macros
• Attaching macros to a form or report event
Custom Menus & Toolbars
• Creating Custom Menus
• Creating New Toolbars
• Attaching a custom menu/toolbars to a form
Creating a Menu Form
• Menu Form Properties
• Setting Startup Defaults
Database Documentation
Useful For:
Availability:
Our Experience: