Course description
Intermediate Microsoft Access
This course is for anybody wanting to increase their knowledge in Microsoft Access and looks at Microsoft 365 but also looks at previous versions, of 2016, 2013, 2010 or 2007, as it covers all the aspects and differences between the versions. It helps participants improve their knowledge and skills to ensure that they are able to maximise the full use of MS Access.
To ensure success, participants should have completed our Basic Microsoft Access course or are familiar with the topics in this course
Upcoming start dates
Suitability - Who should attend?
Who should attend?
Anybody wanting to learn intermediate Microsoft Access functions
Outcome / Qualification etc.
By the end of the course, participants will be able to:
- Understand intermediate functions of Microsoft Access
Training Course Content
- Introduction
- Ribbons
- Basic Database Structure
- Using a Database
- Creating a Table
- Planning Your Database Fields
- Defining Your Fields in Design View
- The Datasheet View
- Primary, Secondary & Multiple Keys
- Entering Data to Create Fields
- Data Types
- Deleting Fields
- Entering Data
- Using the Attachment Data Type
- Sorting, Finding and Filtering
- The Home Ribbon
- Totals
- Normalization
- Relating Tables
- Defining Table Relationships
- One-to-One Relationships
- One-to-Many Relationships
- Referential Integrity
- Many-to-Many Relationships
- Using the Lookup Wizard
- Setting Cascading Deletes
- Update Cascades
- Entering Data into Related Tables
- Importing & Exporting Data
- Importing an Existing Spreadsheet into Access
- Exporting from Access to Excel
- Mail Merge with Access & Word
- Create Email Forms
Expenses
Course Price:£180 + VAT
Request info
Oakley Services UK Ltd
Since its founding in 2007, Oakley Services UK Ltd trading as Oakley Training and Consultancy provides efficient, engaging, and practical training and consultancy covering a wide range of popular business needs. Hosted from our Head Office and dedicated training facility...