Microsoft Access  - IntensiveDownload Course Outline

This is the outline of our Microsoft Access Intensive course - Duration: 3 days

If you’re in the business of managing data, then using Access to handle the creation, manipulation and analysis of your organisation’s data will give you powerful solutions. This course gives you the skills to design a more complex relational database by learning how to create and link tables. With the use of more advanced queries, you will also learn how efficiently you can extract and manipulate information. You will find out how to design professional looking Access forms to simplify data entry and make data enquiries more powerful and with the use of Access reports you will be able to communicate information more effectively.  You will also be introduced to the concept of database automation with the use of macros and command buttons. 

You don’t need any previous experience of designing databases but you should be reasonably confident in general computer use and want to learn how to design a more complex Access Database.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.

Microsoft Access  - Intensive course content

Download a PDF course outline using the link on the right.

Introduction to the Access Environment

  • Explain the correct use of Tables, Queries, Forms and Reports in a Relational Database.

Working with Records

  • Accurately enter, edit and delete records in an Access Table.

Designing Tables

  • Use Table Design View to create fields with their correct field types.
  • Control the data in fields by assigning the correct Field Properties.
  • Explain correctly the use of Primary Keys.

Creating Table Relationships

  • Explain the use of table relationships correctly
  • Explain why you would want to Enforce Referential Integrity.
  • Correctly link tables in one-to-many relationships.

Design Advanced Queries

  • Find records in tables based on multiple criteria.
  • Use Queries to find  data across linked tables.
  • Enter the criteria correctly when you run a query.
  • Use queries to find totals, averages and how many?
  • Construct the IIF  function correctly to return values into a query based on the result of a test.
  • Explain the correct use of an Equi-Join
  • Explain the correct use of Inner Joins

 

 

Design Advanced Reports

  • Design complex reports where records are grouped under section headers and footers
  • Correctly add your own calculations into reports.

Design Advanced Forms

  • Design complex  forms to accurately show data from one or more tables or queries.
  • Add and customise bound and unbound combo boxes that accurately show a selection of values from which the user can choose.
  • Add an unbound textbox onto a form into which you can put your own expression.
  • Use concatenation to bring together strings and expressions
  • Correctly use Dlookup to find values from unrelated tables.
  • Correctly design Subforms to show the “many” side of a one-to-many relationship.

Advanced Database Design Techniques

  • Correctly reference values from other database objects on a form or query e.g find a value on a form to put into query criteria.
  • Start Access and display your own form instead of the Database Window.

Form Automation

  • Use command buttons to automatically open and close forms and reports using Macros and  VBA.