How we deliver Access courses
Onsite Courses
- We come to you
- We bring all the equipment needed
- The outline can be customised
£500 per day plus vat
(additional expenses may be payable)
Open Course Dates
- You come to our venue
- Suitable for individuals
£150 per day per person
Access Basic
Our Microsoft Access Basic course gives you a grounding in access and will enable you to build simple database systems that can benefit your business. It is expected that you will have a certain basic knowledge of using a computers but no prior experience with Microsoft Access.
Getting started
Database concepts
Exploring the Microsoft Access environment
Getting help
Closing a database and Access
Databases and tables
Planning and designing an Access databases
Exploring Database tables
Creating Database tables
Fields and records
Changing the design of a database table
Finding and editing Database records
Organizing Database records
Data entry rules
Setting database field properties
Working with input masks
Setting validation rules
Using indexes
Simple database queries
Creating and using queries
Modifying query results and queries
Performing operations in queries
Access forms
Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, and filtering records
Access reports
Creating reports
Modifying and printing reports
Access Intermediate
Our Microsoft Access Intermediate course builds on your prior knowledge and enables you to create a more flexible and robust database system making it much easier for the user to operate. It is expected that you will have experience or training within Microsoft Access.
Relational databases
Database normalization
Relating MS Access tables
Implementing referential integrity
Working with related tables
Lookup fields
Modifying Lookup fields
Subdatasheets
Complex queries
Joining tables in MS Access queries
Creating calculated fields
Summarizing and grouping values
Advanced form design
Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
Advanced reports
Customized headers and footers
Adding calculated values
Sub-reports
Charts
Charts in forms
Charts in reports
PivotTables and PivotCharts
MS Access PivotTables
Modifying PivotTables
PivotCharts
Internet integration
Hyperlink fields
Access Advanced
Our Microsoft Access Advanced course introduces techniques employed by professional application developers providing you with the skills to build feature rich database systems. It is expected that you will have experience or training within Microsoft Access.
Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls
Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries
Macros
Creating, running, and modifying macros
Attaching macros to the events of database objects
Advanced Macros
Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer
Importing, exporting, and linking objects
Importing objects
Exporting objects
Interacting with the XML documents
Linking Access objects
Working with Windows SharePoint Services
Database management
Optimizing resources
Replicating and synchronizing databases
Security fundamentals
Protecting databases
Encrypting and decrypting databases
User-level security