Access Intermediate
Software: Microsoft Access
Training Course: Intermediate Microsoft Access
Location: London
To book call: 0700 233 6600 or click here
Summary: This course provides people with some experience of Microsoft Access , the opportunity to learn new skills in Access and to be able to complete more complex tasks.
Pre-requisites: All attendees to Microsoft Access Courses must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered on our Microsoft Access 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
Objectives: This hands-on course will enable participants to identify and describe the component features that collectively make up Microsoft Access . Participants will be able to build database objects including Tables, Queries, Simple Forms and Reports.
Who should attend: Our ‘Microsoft Access 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.
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.
Public Course Cost. £220.00
Reward Price. £110.00
Company Room Rates & Work Shops – Please call for quote Associated courses: Access Advanced; Access Programming
