Opleiding: 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:
- That participants, after completing the Incompany training, have a good understanding of Microsoft Access 2019 Basic.
- That participants, after the training, can easily navigate Microsoft Access 2019 Basic.
- That participants are able to carry out daily tasks using Microsoft Access 2019 Basic.
- 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.
