Microsoft Access Advanced
Short course
In Cardiff
Description
-
Type
Short course
-
Level
Advanced
-
Location
Cardiff (Wales)
-
Duration
1 Day
Suitable for: This course has been created for competent users of Microsoft Access who wish to deepen their expertise of this software and learn useful hints and tips of using this software in a commercial environment.
Facilities
Location
Start date
Start date
About this course
You must be a competent users of Microsoft Access
Reviews
Teachers and trainers (1)
Mark Rastin
Trainer
Course programme
This training course is designed to give learners an advanced knowledge of Microsoft Access.
You will be taught how to create an use Macros as well as being introduced to structured query language. You will also be introduced to visual basic concepts. By the end of this training you will have a confident and complex knowledge of Microsoft Access. Course Content Designing Tables Normalising data Introducing Structured Query Language SQL queries, sub-queries, commands and joins Inserting, updating and deleting data Working with Macros Creating Macros Testing and Debugging Macros Modifying Macros Adding Macros to Forms and Reports Programming Access Macros versus Visual Basic Visual Basic Concepts Data Access Pages Creating, Modifying and Sorting Data Access Pages Editing and Protecting Converting Access Databases Converting from Access ’97, 2000 to 2003/2007 Managing and Maintaining Optimizing with Table Analyser, Performance Analyser and Documenter Analyser
Microsoft Access Advanced