Where would you like to study?

We’ve got locations in three of the best cities in Ireland. If you know exactly where you’d like to study, just pick the one that suits you best. If you don’t know yet – then that’s fine too!

Griffith College Logo

Microsoft Access - Advanced

Microsoft Access - Advanced

Overview

Participants will be provided with an in-depth knowledge of Access the opportunity to go beyond simple tasks and concentrate on using Access to its full extent.

This course is designed for busy people who need to develop their own Databases. If you have to build a database from scratch or enhance an existing one, and are familiar with our Introductory and Intermediate levels, this course will develop your skills further. The course will also enable participants to obtain an in-depth understanding of the more complex components that make up Microsoft Access.

Course details
Modules
Using The Northwind Database
  • Installing The Northwind Database
Structured Query Language
  • Writing SQL Commands
  • Writing SQL Queries
  • Writing SQL Sub-Queries
  • Writing SQL Joins
  • Inserting Data
  • Updating Data
  • Deleting Data
  • Writing SQL Queries In Access
Working with Macros
  • Automating Tasks
  • Introducing The Macro Design Toolbar
  • Creating Macros
  • Testing And Debugging Macros
  • Modifying Macros
  • Conditional Programming In Macros
  • Adding Macros To Forms
  • Adding Macros To Reports
  • Filtering Data
  • Documenting Macros
Using Visual Basic
  • Using Macros Versus Visual Basic
  • Understanding Visual Basic Concepts
  • Using The Visual Basic Editor Window
  • Getting Help With Visual Basic
Using Data Access Pages
  • Creating Data Access Pages
  • Modifying Data Access Pages
  • Sorting Data In Data Access Pages
  • Summarising Data In Data Access Pages
  • Editing Data In Data Access Pages
  • Protecting Data In Data Access Pages
Converting Access Databases
  • Converting Databases To Access
  • Converting From Access 2003 To Access 97
  • Converting From Access 2003 To Access 2000
Customising Access
  • Configuring Access Options
  • Configuring AutoCorrect Options
  • Customising Menus And Toolbars
Managing & Maintaining Databases
  • Optimising Databases With Table Analyzer
  • Optimising Databases With Performance Analyzer
  • Documenting Databases With Documenter Analyzer
  • Avoiding Errors With The Object Dependencies Task Pane

Course Contacts

If you have any questions please get in touch with us at [email protected] or 01 415 0429.

Timetables

This course is available as customised training please contact [email protected] for further information about this option.

 
 
How to Apply

How to apply

Directly to Griffith College Short Courses Department

Fees

Study mode: Part-time.

Fee: Available upon request.

CTA1

Ready to take the next step?