Microsoft Access Training Courses
Enliten IT’s Microsoft Access training courses start with good database design principles through to data manipulation using tables, queries, reports and VBA. Whichever training course you choose you will find lots of useful tips and tricks for getting the most out of MS Access so that you'll be more productive at work.
We have Microsoft Access trainers in London, Essex, Cambridgeshire, Hertfordshire and throughout the UK so most of our clients take advantage of our, cost effective, tailored onsite training options (we come to you). Alternatively, you can come to one of our training centres.
We train on ALL versions of MS Access, please call for older version course outlines.
Access 2019 Introduction course
2 days
This Microsoft Access 2019 Introduction course provides delegates to the necessary skills to create straightforward databases from scratch. Starting with an understanding of database design principles, through to hands-on work in creating databases that you can easily be managed through basic tasks such as entering and editing data through to finding, sorting, retrieving, reporting and analysing data.
Download PDFWhat will you learn?
- Design and create a database
- Create tables and set the primary key
- Enter/edit data
- Find data in tables
- Create Queries and Table relationships
- Design and create Forms and Reports
- Print reports
- Prerequisites
Audience?
Course Contents
Introduction
- Overview of Database concepts
- Database Design tips & Planning
- Screen layout, Ribbons
- Backstage view
- Database Objects
- Object Types
On-Line Help
- Wizard & Index
Field Properties Explained
- Properties: Field Size, Format, Decimal places, Caption, Default Value, Required, Indexed
- Validation Rules
- Input Mask
Create and Find
- Create and Edit records
- Select/Save/Delete records
- Navigating records
- Sorting records
- Find & Replace
Filters
- By Selection/Form
- Using AND/OR
- Save as a Select Query
Tables
- Creating a New Database
- Designing Tables
- Design and Datasheet View
- Field Names and Data Types
- Primary Key
- Fields in Tables
Editing Tables
- Adding / Editing / Deleting records
- Analysing a Table
- Relationship in Splits
- Modifying Tables
- Lookup and Hyperlink Column
Relationships
- Create a Relationship
- Referential Integrity
- Many-to-Many Relationships
- Lookup fields
Queries & Operators
- Queries and RecordSets
- Simple Query Wizard
- Add Tables to a Query
- Join Tables in a Query
- Use Operators
- Calculated Fields & Concatenate
- Using Parameters
- Action Queries
- AND/OR/BETWEEN/NOT/NULL
- Wildcards
Advanced Queries
- Top Values in Query
- Calculated Field
- Function Query
- Parameter Query
- Concatenation Query
- Multiple Tables in Query
- Inner & Outer Joins
Query Modification
- Sort Query
- Add Criteria/Record
- Hide Fields
- Print Query
- Analysis Table
- Relationships in Splits
- Table Analyser
Forms
- Using Forms Wizard
- Design & Layout view to create/edit forms
- Viewing, Editing and Printing
- Control types and Control properties
- Selecting & Formatting controls
- AutoForm
Reports
- Create AutoReports
- Use and Format Reports
- The Reports Wizard
- Print Reports (inc. headers & footers)
Printing
- Table Data
- Page Setup and Selected Records
- Print to PDF
Course Materials
Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.
“Excellent, I am really looking forward to the advanced course now.”I am really looking forward to the advanced course now
Prerequisites
Additional Information
Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
The suggested course duration is a guideline. Course topics and duration on this Microsoft Access 2019 Introduction course may be modified by the instructor based upon the knowledge and skill level of the course participants.
