Access 2019 Intermediate

Our comprehensive program is meticulously crafted to equip you with the essential skills and knowledge required to thrive in your chosen field. Developed by seasoned professionals with years of industry experience, this course is ideal for those seeking to kickstart their careers or enhance their existing skill set.

Featuring an engaging audio-visual presentation and easily digestible modules, our program facilitates a self-paced learning experience. Our dedicated online support team is available on weekdays to provide assistance throughout your journey.

Key Learning Outcomes

• Grasp the fundamentals and their practical applications.
• Cultivate the necessary skills for success in your field.
• Apply newfound knowledge to real-world scenarios.
• Develop effective solutions for relevant topics.
• Elevate your employability and career prospects.

Course Curriculum

• Module 01: Introduction to the Course
• Module 02: Reviewing Table Design Principles
• Module 03: Setting Field Size, Formats and Captions
• Module 04: Setting Default Values and Required Fields
• Module 05: Restricting Data Entry-Validation Rules
• Module 06: Restricting Data Entry-Input Masks
• Module 07: Exploring Tables and Queries to Excel
• Module 08: Exporting Data to a SharePoint List
• Module 09: Importing Data from Excel
• Module 10: Importing Data from a Sharepoint List
• Module 11: Linking External Data Sources
• Module 12: Using Word Merge
• Module 13: What are Action Queries
• Module 14: Creating an Update Query
• Module 15: Creating an Append Query
• Module 16: Creating a Delete Query
• Module 17: Creating a Make Table Query
• Module 18: Changing Start Number of an Auto Number Field
• Module 19: Modifying Query Joins
• Module 20: Using Self Joins to Combine Data
• Module 21: Creating Find Unmatched and Find Duplicate Queries
• Module 22: Creating Parameter Queries
• Module 23: Creating a Top X Query
• Module 24: Reviewing Calculated Query Fields
• Module 25: Summarising Query Data with Totals
• Module 26: Creating a Crosstab Query
• Module 27: Understanding Macro Basics
• Module 28: Creating Macros to Open Forms by Record
• Module 29: Validating Data Entry with Macros
• Module 30: Creating a Macro to Automate Data Entry
• Module 31: Advanced Data Entry Using Macros and DLOOKUP Functions
• Module 32: Using Conditional Formatting
• Module 33: Working with the New Label Name Property
• Module 34: Organising Form Fields with Tab Controls
• Module 35: Creating an Option Group Control
• Module 36: Creating a Combo Box Control
• Module 37: Configuring a Combo Box Control to Show Search Results
• Module 38: Using a Subform to Show Data from a Related Table
• Module 39: Inserting a Chart on a Report
• Module 40: Showing Data in Columns
• Module 41: Inserting a Subreport
• Module 42: Configuring Reports with Parameter Queries
• Module 43: Sending Reports

Designed to give you a competitive edge in the job market, this course offers lifetime access to materials and the flexibility to learn at your own pace, from the comfort of your home.

Why Choose Us?

• Learn at your own pace with 24/7 online access to course materials.
• Benefit from full tutor support available Monday through Friday.
• Acquire essential skills in the convenience of your home through informative video modules.
• Enjoy 24/7 assistance and advice via email and live chat.
• Study on your preferred device – computer, tablet, or mobile.
• Gain a thorough understanding of the course content.
• Improve professional skills and earning potential upon completion.
• Access lifetime course materials and expert guidance.
• Enjoy the convenience of online learning with flexible schedules.

Why Enroll in This Course?

Our program provides a comprehensive introduction to the subject matter, laying a solid foundation for further study. It empowers students to acquire knowledge and skills applicable to both their professional and personal lives.

Assessment

The course incorporates quizzes to evaluate your understanding and retention of the material. These quizzes pinpoint areas for further practice, allowing you to review course materials as needed. Successfully passing the final quiz qualifies you for a certificate of achievement.

Requirements

There are no formal requirements for this course, it is open to anyone who is interested in learning the material.

Career Path

Our course is meticulously designed to equip you for success in your chosen field. Upon completion, you’ll have the qualifications to pursue diverse career opportunities across various industries.