Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Access - Intermediate

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

Objectives: This hands-on course will enable participants to identify and describe the component features that collectively make up the application. Participants will be able to build database objects including Tables, Queries, Simple Forms and Reports.

Overview of Content Additional principles of table design: Using Lookup fields. Using Object Linking and embedding using Hyperlinks. Review / identify Data types and their field properties.

Using Specialised Queries: Parameter Queries. Updating Records. Copying data to a table. Querying to delete records from tables. Creating a table from query results. Using the expression builder. Creating Crosstab Queries. Calculating in Queries. Grouping. Multiple table queries.

Managing Relationships: Establishing Relationships. Editing relationships. Joining tables in a query.

Importing and Exporting Data: Importing Data into Access. Linking to data. Importing data from Excel. Creating a mail merge with Word. Exporting data from Access to another database. Copying data to another program. Copying data to another Access Database. Copying a table within a database.

Additional Working with Forms: Specifying properties in forms. Adding controls. Creating a drop down data entry list. Modifying controls. Creating Subforms. Creating charts on forms.

Additional Working with Reports: Fine tuning your reports. Making mailing labels. Printing reports. Saving reports as word documents. Using the Expression Builder.
Regions:
  • London
  • Midlands
  • South East England
  • South West England
Delivery:
  • In House
  • Public
Category:
Difficulty:
  • Intermediate

Further Details

Who should attend: Our ‘Intermediate’ course is designed for busy people who need to know how to get the best from Access from the outset. If you are required to work beyond the basic use of Access for Data Input, or need to progress to build your own Tables and Queries, this course will point you in the right direction.

Pre-requisites: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered on our introduction course, either directly by attending the course, or having had hands on experience of the areas covered.

Duration: 1-Day

Start & Finish Times: 10am to 5pm

Guide price

£195 +VAT

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net