Microsoft Access Training Course 2003 Intermediate

Overview and objectives of the Microsoft Access Training Course

This Microsoft Access Training Course  will help you obtain skills required to create an efficient  relational database. You will learn the concepts of  relational database

You will learn to customise forms, reports, and Data Access Pages and you will learn to calculate and summarise data and to import and export data in different formats for mail merge, analysis in Microsoft Excel, or for reporting purposes.
 

Who is this Microsoft Access Training Course for?

If you want to be able to  to design relational database structures using Microsoft Access, by using advanced queries, forms & reports, this course is for you

Microsoft Access Training Course prerequisites

Delegates should have ideally attended the Microsoft Access Introduction Training Course.

Microsoft Access Training Course Contents

Designing a Relational Database with Microsoft Access 

Basic principles of relational database management systems, Normalise a database into relational tables using key fields, Applying referential integrity, Relational database table  design.

Creating Table Relationships in Microsoft Access 

Create and edit table relationships, Arrange tables in the Relationship window, Enforce referential integrity, Use the Lookup Wizard, Modify a lookup list, Display related records in a subdatasheet  

Joining Tables with Queries in Microsoft Access  

Create and modify a multi-table select query, Specify join properties for relationships, Understand the effect of join types in a query, Use self joins and cross joins  

Summarising and Calculating Data in Microsoft Access  

Create a query to summarise values, Add a calculated field to query output, Apply query properties, Add a calculated field to form or report, Use the Expression Builder to create expressions  

Creating Summary Reports in Microsoft Access  

Create a summary report using the Report Wizard, Modify group properties, Add and remove group headers and footers, Modify group and detail section sort orders, Modify report section properties  

Designing Forms and Reports in Microsoft Access  

Create a new form or report in design view, Understand the use of different sections, Display, hide, and resize a section, Modify form/report, section, and control properties, Add a bound control, Use the Control Wizard to add a control (list box, combo box, check box, option group), Add a hyperlink control

Modifying Controls in Microsoft Access

Select a single control or multiple controls, Move, resize, align, and distribute controls, Change the tab order of controls on a form, Identify and resolve errors, Modify control properties, Insert a graphic control, Set control defaults, Create a form/report template  

Importing Data  into Microsoft Access

Import data from different sources (spreadsheet, text file, database, Outlook/Exchange Address Book), Use Drag-and-Drop and the Clipboard to copy and paste data  

Exporting Data from Microsoft Access 

Export a table or query to Excel, Export data to Word and complete a mail merge, Create a report snapshot, Save data in other file formats, Export data objects to a different database, Save a table, query, or form as a web page, Export data to XML  

Designing a Data Access Pages in Microsoft Access  

Create a Data Access Page, Modify the connection properties of a data access page, Use the grouping and sorting features of a data access page, Modify the design of a data access page, Add and modify fields and controls, Delete a data access page

Managing the Database File

Document database structure, Identify object dependencies, Compact and repair a database, Apply password protection to a database file, Encrypt and decrypt a database, Convert a database between different Access versions