Access Introduction

Who should attend

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!

Team Pass by Learnit

Access Introduction

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: 

    • Introduction into How Databases Operate 
      • Learning the Access Interface 
        • Creating A New Database 
          • Designing and Creating New Tables 
            • Entering Data into Tables 
              • Sorting and Filtering Data 
                • Introduction into Relating Table Data 
                  • Create Commonly Used Queries 
                    • Customizing Queries with Criteria 
                      • Using Forms for Data Entry 
                        • Create Reports for Data Output 
                        Course ID
                        ACCESSauml
                        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 1

                        Introduction into How Databases Operate

                        • Exploring a Relational Database
                        • Examining Database Objects 
                        • How Data Is Related Between Tables 

                        Learning the Access Interface

                        • Examining Access Menu Tabs 
                        • Using the Access Navigation Pane 
                        • Using the Data View and Design View of an Object 

                        Creating A New Database

                        • Planning Steps to Create a New Database

                        Designing and Creating New Tables

                        • Create Tables in Design View
                        • Import Data from Excel

                        Entering Data into Tables

                        • Data Entry Techniques and Shortcuts 

                        Sorting and Filtering Data

                        • Re-arranging Records by Sorting 
                        • Hiding Records Using Filtering 

                        Introduction into Relating Table Data

                        • Using the Relationships Window 

                        Create Commonly Used Queries

                        • Using the Simple Query Wizard 
                        • Creating Queries in Design View 

                        Customizing Queries with Criteria

                        • Adding Criteria for Text, Number, And Date Fields
                        • Introduction into Using Wildcards in Criteria 

                        Module 2

                        Using Forms for Data Entry

                        • Creating Forms
                        • Exploring Different Form Layouts
                        • Perform Data Entry in Forms

                        Create Reports for Data Output

                        • Basing Reports on Queries 
                        • Previewing and Printing Reports 
                        • Understanding the Report Design Interface 
                        • Formatting Reports for Professional-Looking Output 

                        Skills covered

                        No items found.