Griffith College Logo

Microsoft Access - Intermediate

Microsoft Access - Intermediate

Overview

This course provides people who already have some experience of Microsoft Access, the opportunity to learn new skills in Access and to be able to complete more complex tasks.

This course is for participants who wish to be able to design and build databases incorporating the use of forms, queries and reports, design queries to extract information from the database and export that information into other windows based products, such as Microsoft Excel. You will also be able to use the security features of Microsoft Access to give different users different levels of access to the database.

 

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

Fees: Available upon request

CTA1

Ready to take the next step?