Access 2019 Basic - Microsoft Access - Microsoft Office - Databases - Database design - Data quality - Data management - Data analysis - SQL

Access 2019 Basic

For an Incompany training course in Access 2019 Basic, we offer you a complete solution. Our advisors are happy to help you identify your needs and requirements, and our mission is to ensure you get the most out of the training. That’s why we also offer tailor-made training courses that match your needs exactly.

A Microsoft Partner for Your Incompany Training

The plan of approach could look as follows, and we are happy to discuss this with you to arrive at a customized solution that is fully arranged from A to Z through the Splendid Learning Model.

Objectives of an Access 2019 Basic Incompany Training:

1. That participants, after completing the Incompany training, have a good understanding of Microsoft Access 2019 Basic.
2. That participants, after the training, can easily navigate Microsoft Access 2019 Basic.
3. That participants are able to carry out daily tasks using Microsoft Access 2019 Basic.
4. That participants are motivated to use Microsoft Access 2019 Basic more efficiently.

1. Initial Assessment

We offer a free phone consultation with our Microsoft Certified Trainer (MCT), who is also a Microsoft Office Specialist (MOS) Master, to determine the current skill level and discuss the objectives with expert advice.

2. Incompany Training

Participants will receive a professional theoretical and practical Incompany training in Dutch or English, or in Dutch with English Office software (customized), on-site at your location. You may provide your own practice materials to be included in the training.

Your organization invites participants via email.
We review the target group and learning objectives, and select an appropriate MOS Master trainer and corresponding course materials (if desired).
Evening or weekend training and laptop rental are also possible.

3. Evaluation and Completion

At the end of the Incompany training, there is an evaluation, and participants receive a certificate of participation, visible in the user's profile via our LMS system or App. With this app, all OEM Office E-Learning Menu participants can edit their profile and download/view certificates.

4. Reference Material

Our practical course books cover in detail the various features of Microsoft Office. These books are ideal for those who want to work faster and more efficiently and get the most out of Microsoft Office. The course books contain hundreds of pages, including practice exercises and full topic coverage.

5. Follow-up Support

In consultation, email support is available for 3 months to ask questions related to the course content.

Course Content

Basic Skills

• Navigating the Access screen
• "Tell me what you want to do..." feature
• New Access templates (version 2016)
• Using Help
• Viewing and printing objects
• Creating a database

Table Design

• Designing a table
• Entering and deleting data
• Formatting a datasheet
• Filtering and sorting tables
• Creating hyperlinks
• Using the Table Wizard

Modifying Field Properties

• Using default values
• Required fields
• Limiting values
• Changing formatting properties
• Using input masks

Form Design

• Manually designing a form
• Changing view settings
• Modifying controls
• Changing tab order
• Creating calculated fields
• Using the Form Wizard

Relationships Between Data

• Normalization
• Creating table relationships
• Using the Relationships window
• Referential integrity
• Working with subdatasheets

Running Queries

• Creating a select query
• Sorting data
• Defining criteria
• Using multiple criteria: AND/OR
• Performing calculations in a query
• Using the Query Wizard

Creating Reports

• Report Wizard
• Designing report layout
• Modifying display properties
• Sorting/grouping
• Creating calculated fields
• Printing a report

Importing and Exporting

• Exporting to Excel
• Importing an Excel worksheet
• Working with text files
• Working with HTML
• Importing a database file
• Importing an Access object

Access and SharePoint

• Collaborating in Access Web App
  (only in combination with SharePoint on-premises)

Request Incompany Training

Contact us or request a quote here.