National Computer Training Network
Microsoft Access - Introduction 2003
Duration: 2 days
This course is designed for people who need to understand and use databases in Access 2003. Participants will learn how to use Access to input, organise and manipulate data and customise forms and reports. On the second day of the course participants will create a simple database.
Topics Include:
- Working with Databases
- Starting Access 2003
- Working with Tables
- Working with Forms
- Working with Reports
- Creating Tables
- Table Properties
- Editing Data Types, Field Properties and Data.
- Creating Forms
- Modifying Forms Design
 Access 2003 Introduction Course Description (137 KB)
Microsoft Access - Introduction 2007
Duration: 2 days
Access Introduction is for people new to databases and for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate and Advanced courses.
Topics Include:
- Exploring Access
- Creating Tables
- Working with Tables
- Editing Tables
- Finding & Filtering Data
- Printing Data
- Creating Relationships
- Using Simple Queries
- Modifying Query Results
- Creating Basic Forms
- Creating Basic Reports
- Modifying Tables
- Setting Field Properties
- Using Operators in Queries
- Designing Advanced Queries
- Using Advanced Query Wizard
- Manipulating Form Controls in Design View
- Using Design View
- Using Editing Tools
- Using Advanced Form Design
- Using Advanced Report Design
Access 2007 Introduction Course Description (237 KB)
Microsoft Access - Intermediate 2003
Duration: 2 days
This course is designed for people who are existing users of Access databases and wish to be able to modify and enhance existing databases. The course covers the features that are used to create more advanced queries, forms and reports, and expressions to effectively manipulating data.
Topics Include:
- Comparison Operators in Queries
- Actions Queries
- Advanced Queries
- Customising Forms
- Form Controls and Properties
- Reporting
- SubReports
- SubForms
- Using Expressions
- Macros
Access 2003 Intermediate Course Description (63 KB)
Microsoft Access - Intermediate 2007
Duration: 1 day
Access Intermediate is for people who can already create simple databases, and want a Forms-driven database with basic automation.
Topics Include:
- Exporting Data
- Using Advanced Database Features
- Using Subforms/Subreports
- Using PivotTables and PivotCharts
- Using Other Form Techniques
- Using Controls and Layouts
- Using Charts
- Creating Macros
- Using Macros
- Customising the Navigation Pane
Access 2007 Intermediate Course Description (196 KB)
Microsoft Access - Advanced 2003
Duration: 2 days
This course is designed for people who are experienced users of Access databases. The course builds on existing database covering the aspects required to develop a front-end of a database system including the use of advanced queries, advanced form and reporting techniques. This course also introduces the fundamentals necessary to develop successful custom multi-user applications in Access.
Topics Include:
- Advanced Queries
- Advanced Forms
- Advanced Form Controls
- Using Switchboards
- Macros
- Advanced Reports
- Custom Toolbars
- Integrating With Other Applications
- Creating Charts
- Multi-User Applications
- Database Maintenance
Access 2003 Advanced Course Description (141 KB)
To find out more please contact us.
Other computer courses that may be of interest:
|
