Access Intermediate

Access Intermediate

Requirements:
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.
Additional principles of table design: Using Lookup fields. Using Object Linking and embedding using Hyperlinks. Revie- / 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.