Course description
Who is this course for?
With basic skills and some experience of Microsoft Access, the topics covered on this course will help you to enhance your relational database.
Content
Database Structure
Review of the elements of an Access database and the importance of table relationships.
Advanced Querying
Grouping in queries.
Creating cross-tab queries.
An introduction to the SQL (Structured Query Language) behind queries.
Creating & using Union queries.
Linking Tables/Importing & Exporting
Importing data and structures from other database applications.
Linking data to other database applications.
Exporting data to Microsoft Word and Excel.
An Overview of Macros & Modules
Explaining the differences and benefits of Macros and VBA Modules.
Creating macros to assist users with navigation through an application and other routines.
Assigning macros to buttons and designing end-user forms.
An introduction to the VBA programming power within Access modules.
Reading and writing simple procedures with and without Wizards.
Database Security
An overview of the security model and its application.
Understanding object permissions and ownership.
Setting a database password.
Setting up User and Group accounts.
Changing User and Group Permissions.
Starting your application using workgroups.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.