-
A hands-on, instructor-led Microsoft Access training course helping people looking to learn the basic skills to begin creating and working with databases effectively. This is achieved by learning, discussion and practice with an open and friendly trainer in a professional classroom environment.
Pricing
- 1 Day of group training is £799 + VAT per day
- 2 Days of group training is £699 + VAT per day
- 3 Days of group training is £649 + VAT per day
- Solo training is available for £450 + VAT per day
Whats covered in this course
-
Getting Started
-
Database Concepts
-
Screen Layout
-
-
Working with an Existing Database
-
Adding New Records
-
Finding Records
-
Sorting and Filtering
-
Datasheet View
-
Changing the Format
-
Row Height
-
Column Width
-
Hiding / Unhiding Columns
-
Freezing Columns
-
-
Tables
-
Designing a New Table
-
Field Names
-
Data Types
-
Naming Conventions
-
Primary Key
-
-
Reports
-
Report Wizard
-
Formatting reports
-
-
Forms
-
Creating New Forms
-
Using the Wizard
-
Designing a New Form
-
Selecting Fields
-
Aligning and Spacing out Fields
-
Formatting Fields
-
-
Queries
-
Working in Design View
-
Using Criteria
-
Wildcards
-
Comparison Operators
-
Sorting
-
Adding tables
-
-
Relationships
-
Relationship Window
-
Types of relationships
-
Linking Tables
-
-
A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.
-
We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.
-
Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.