Access Intermediate

Who should attend

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access! Access Introduction level training is recommended.

Team Pass by Learnit

Access Intermediate

From $0
Two, 2-hour Modules (9am - 11:30am PT)

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Learning Outcomes: 

    • How Table Relationships Affect Queries 
      • Controlling Query Results with Join Types 
        • Creating Complex Queries with Multiple Criteria 
          • Calculating Data with Queries 
            • Automating Queries with Parameters 
              • Using Query Wizards 
                • Exploring Action Queries 
                  • Advanced Report Design Techniques 
                  Course ID
                  ACCESSf1Po
                  Available times
                  June 17 & June 18, 2021
                  9:00am-11:30am
                  June 17 & June 18, 2021
                  9:00am-11:30am
                  June 17 & June 18, 2021
                  9:00am-11:30am
                  June 17 & June 18, 2021
                  9:00am-11:30am
                  June 17, 2021
                  9:00am-11:30am
                  June 17, 2021
                  9:00am-11:30am
                  June 17, 2021
                  9:00am-11:30am
                  June 17, 2021
                  9:00am-11:30am
                  June 17, 2021
                  9:00am-11:30am

                  Course Outline

                  Module 3

                  How Table Relationships Affect Queries

                  • Creating Relationships Between Tables
                  • Add Relationship Security

                  Controlling Query Results with Join Types

                  • How Relationships Affect Query Results
                  • Using Join-Types to Affect Query Results

                  Creating Complex Queries with Multiple Criteria

                  • Applying Wildcards
                  • Using And / Or Conditions

                  Calculating Data with Queries

                  • Create Custom Fields with Calculations 
                  • Summarize Data with Grouping 

                  Module 4

                  Automating Queries with Parameters

                  • Creating Automated Requests for Criteria
                  • Using Wildcards in Parameter Queries
                  • Using Range Operators in Parameter Queries 

                  Using Query Wizards

                  • Getting Non-Matching Records with the Un-Matched Query Wizard
                  • Finding Duplicate Records with the Duplicate Query Wizard

                  Exploring Action Queries

                  • Create Tables with a Make-Table Query
                  • Add Records to a Table with an Append Query
                  • Change Data with an Update Query
                  • Delete Data with a Delete Query

                  Advanced Report Design Techniques

                  • Understanding Report Control Types
                  • Grouping Report Data
                  • Summarizing Report Data

                  Skills covered

                  No items found.