Market leading Microsoft Access training courses
Our three levels of Microsoft Access training will take you through database design, creation, customisation, automation and security.
94%Delegate satisfaction rating
???Delivered wherever you require
1Detailed reference guide included
500,000+End users trained since 1998
This practical, hands-on course is designed for database users who need to acquire Access skills quickly and effectively. Practice tasks and case studies ensure that fundamental techniques can be applied quickly in a demanding financial and business environment.
1 Day
No previous knowledge of Access is necessary, but you need to be able to manage and navigate Windows, save and retrieve documents and use a mouse to select data.
Overview of Access:
The concept of a relational database; managing information effectively; working with databases and how Access objects work together to allow you to add, edit, find and report on information.
Creating databases and tables:
Creating a table; using the Table Wizard; defining field names and data types; overview of available data types; establishing a primary key; saving the table definition.
Setting field and table properties:
Validating data entry; using the Expression Builder; creating an index.
Creating relationships between tables:
An overview of relationships; defining and understanding one-to-one, one-to-many and many-to-many relationships; normalising data; working with the relationships window; setting referential integrity and related options.
Entering and editing information:
Opening and closing databases and tables; entering data in the datasheet; how records are saved; editing records; shortcuts for entering repeating information and dates; working with sub-datasheets.
Locating, filtering and sorting records:
Finding records; sorting records; sorting on more than one field; defining and applying filters; clearing filters and sorting.
Customising datasheets:
Changing column widths; choosing the font; printing the datasheet.
Selecting data with queries:
Creating queries; refining selection by setting criteria and parameters; adding calculated fields to a query; querying multiple tables; creating summary queries; setting query properties; saving and running queries.
Introducing forms and reports:
Creating basic forms and reports using wizards.
This is a practical hands-on course designed for database users who need to extend their Access skills. Practice tasks and case studies ensure that techniques can be applied quickly in a demanding financial and business environment.
1 Day
The course assumes that you have a basic understanding of relational databases, and that you know how to create tables and select data with queries.
Reviewing Access:
How Access objects work together; the importance of using appropriate relationships in a database; creating and running queries with various criteria.
Working with imported data:
Importing or linking data; importing data from other applications (such as Excel or text files); importing from other Access databases; defining an import specification.
Exporting data:
Exporting to a text file, worksheet or database files; merging Access data with a Word document.
More on queries:
Using the query wizards to find duplicates or unmatched records; using action queries to create tables, delete data, append or update records; summarising information with cross-tab queries and totals.
Creating forms and reports:
Using the form and report wizards to create a basic form and report.
Customising forms:
Using form design view; adding controls; setting properties of controls; setting form properties; changing the tab order.
Customising reports:
Working in design view; report sections and their properties; working with groups; adding subtotals and totals; controlling page breaks.
This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.
1 Day
This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.
Designing forms:
Understanding the design window; form sections; adding controls; bound, unbound and calculated controls; adding tab controls; synchronising sub-forms; using list and combo boxes; using a combo box to set query parameters.
Designing reports:
Designing a report; grouping, sorting and summarising; report sections and properties; controlling layout, pagination and page setup; embedding a sub-report; creating a report snapshot; embedding pictures and graphics in forms and reports.
Understanding events:
Exploring Access events; default behaviours for events; how to customise and control event behaviours.
Automating your database:
Creating macros; adding actions arguments and comments; automating data entry with macros; using macros to print records; creating pop-up forms with macros.
Creating an application:
Toolbars and key assignments: creating custom menus; creating keyboard assignments; customising toolbars; attaching custom toolbars to forms.
Implementing security:
Splitting the database; setting passwords; setting a database password; protecting the front end database; testing security settings.
Our certified training courses will leave you feeling more confident and competent in using the system.
The training can be delivered in any location of your choice. You name it and we'll be there.
We've broken the content down into levels of knowledge, allowing you to learn from any starting point.
We offer the flexibility to cherry-pick specific elements of the course content for additional focus.
Whilst other training providers build training teams with one-off contractors, we have a large group of permanently-employed training consultants, who provide our clients with an expert, flexible service.
meet the team