Microsoft Access 2003
Course Outline
Microsoft Access is an extremely powerful database application that makes it easy to store and manage your information, from simple lists through to complex relational database systems or vast product catalogues.
Our Access course will take you through the basics of creating a new database, running queries on the data and setting up forms to capture data. We can also demonstrate how to automate tasks through the intelligent use of macros, and can even introduce you to the Visual Basic module system for more advanced functionality.
ILA Approved
This course has been ILA approved. This means you could get up to £200 towards the cost of this course. Find out more about using your ILA at Net Resources.
MS Access Course Contents
This represents the breakdown of our typical Microsoft Access training course, however, individual courses can be tailored to fit your purposes.
Access Basics
- Introduction to databases
- Opening a database
- Navigating the Access interface
- About tables
- Adding and editing records
- Selecting data
- Form basics
- Running queries
- Reporting
Advanced functionality
- Field formatting
- Validating data
- Creating and maintaining relationships
- Forming expressions
- Summary functions
- Form design
- Multitable queries
Skills Gained:
- Create, open, and close a database
- Organising and finding data
- Creating data table relationships
- Running queries on data
- Capturing data in forms
- Report creation
Course Details
- Duration: 1 day
- Time: 10:00-16:00
- Cost: £289.00 + VAT
- Dates: Call for details