Access 2003 Advanced
Course Information
This two-day course is designed to explore the opportunites to enhance databases through advanced formatting, customising and automating procedures.
Pre-requisites
Those attending this course should have attended the ‘Introducing Database Design’ course or have equivalent knowledge through their own usage of the product.
Course Objectives
By the end of the course delegates will be able to:
- Create more advanced forms utilising some of the further features available within Access – utilising relationships, properties and custom controls
- Apply simple customising to set how the database should open and what the user can see and access
- Perform mathematical and logical analysis on data using expressions and calculations
- Apply Access mechanisms to secure the database
- Integrate Access data with the other applications in MS Office
- Create copies of a database enabling several people to work on the same database at the same time and from different locations
- Create more advanced reports from Access data
- Utilise built-in macro actions to automate common tasks
- Create databases with advanced relationships using links, joins, indexes and optimise their performance
- Create hyperlinks to quickly move to different objects in Access or to jump to different applications
What you will learn:
Day One
Lesson 1 – Advanced Forms
Utilising Relationships
Custom Controls
Form Properties
Lesson 2 – Controlling Access to a Database
Opening the Database
Restricting Access
Lesson 3 – Analysing the Data
Calculating on field information
Using Expressions
The Expression Builder
Lesson 4 – Securing the Database
Database Properties
Password Protection
Permissions
Day Two
Lesson 5 – Integration with other applications
Import Data
Export Data
Lesson 6 – Multiple User Database
Creating a copy
Multiple access
Lesson 7 – Advanced Reporting
Sorting
Grouping
Calculating
Lesson 8 – Automating Common Tasks
Macro Basics
Creating Macros
Changing the way Macros are activated
Editing Macros
Deleting Macros
Running Macros
Lesson 9 – Advanced Relationships
Links
Joins
Indexing
Optimising Performance
Creating Hyperlinks
Creating hyperlinks to other parts of the database
Creating hyerlinks to other applications
