Access 2019 Course E-Learning

• Language: English
• Target group: ICT beginners and intermediates with some basic knowledge of databases who want to expand their knowledge and learn Access completely
• Level: Beginner and Intermediate
• Required knowledge level: Some knowledge of databases
• Course duration: approximately 4 hours (depending on personal speed)
• Online access: 24/7, 365 days after activation
• Course test included
• Certificate of Participation included

Access Course

You want to know Microsoft Access and the Access 2019 E-learning course is the solution for that. This Access course is so comprehensive that it provides training from A to Z. The Access 2019 course provides all the knowledge from beginner to intermediate.

With as much as 1 year of access, day and night, this Access course gives you the chance to learn the program completely. The course includes extensive interactive videos, is award-winning e-learning, provides practical assignments, and includes progress monitoring.

You are ready to step into the world of Microsoft Access!

Course content

Access 2019: Working with Databases

Course: 25min

• Finding & opening the application
• Using database templates
• Understanding the interface
• Customizing the interface
• Customizing the Quick Access toolbar
• Customizing the ribbon
• Knowledge Check: Working with Databases

Access 2019: Saving, Printing & Exporting Databases

Course: 21min

• Saving your data
• Saving regularly
• Protecting your database
• Printing items in your database
• Exporting your database
• Sending your database table via email
• Knowledge Check: Saving, Printing & Exporting Databases

Access 2019: Tables, Fields & Entries

Course: 34min

• Understanding your database
• Creating a table
• Organizing your database items
• Inserting fields in your table
• Formatting your database fields
• Editing your database field properties
• Linking data in different tables
• Managing data relationships
• Visualizing object dependencies
• Knowledge Check: Tables, Fields & Entries

Access 2019: Inserting, Importing & Formatting Data

Course: 32min

• Inserting data into your table
• Modifying the default editing settings
• Using external data in your database
• Importing your address book from Outlook
• Formatting your data
• Creating dropdown menus
• Creating data validation rules
• Creating labels
• Knowledge Check: Inserting, Importing & Formatting Data

Access 2019: Finding & Organizing Data

Course: 23min

• Sorting your data
• Filtering your data
• Locating a data value
• Replacing data values
• Editing database indexes
• Finding duplicates in your database
• Knowledge Check: Finding & Organizing Data

Access 2019: Creating Forms & Queries

Course: 34min

• Creating a form using the wizard
• Using different form types
• Creating a form from scratch
• Editing form elements
• Creating a simple query
• Creating a crosstab query
• Performing a simple calculation
• Creating a calculated field
• Knowledge Check: Creating Forms & Queries

Access 2019: Customizing Forms

Course: 42min

• Formatting a form
• Inserting a list box in a form
• Inserting check boxes in a form
• Inserting buttons in a form
• Reorganizing your form
• Editing information in your form
• Customizing the appearance of your form
• Editing your form's properties
• Knowledge Check: Customizing Forms

Access 2019: Using the Report & Analysis Tools

Course: 21min

• Creating a quick report
• Creating your own database report
• Customizing your report
• Cleaning up your database
• Analyzing your database
• Knowledge Check: Using the Report & Analysis Tool