Courses

    Pages & Posts

      • IT Training
        • Amazon Cloud (AWS)
        • Analytics and Big Data
        • Blockchain
        • Cisco
        • Citrix
        • Cloud Computing
        • CompTIA Certification
        • Cybersecurity
        • Deep Learning and AI
        • Development Tools
        • DevOps
        • F5
        • FlexPod
        • IBM
        • IT Security
        • Java
        • Juniper Networks
        • Linux
        • Microsoft
        • Mobile Computing
        • NetApp
        • Oracle
        • Salesforce
        • VMware
        • Web Development, HTML, and JavaScript
        • WebSphere
      • Business Training
        • Business Analysis
        • Enterprise Architecture
        • HIPAA Certification & Training
        • IT Governance
        • ITIL® Certification
        • Project Management
        • Salesforce
        • Scrum & Agile
        • Seminars
      • Services
        • APM Practice
        • Authorized Cisco Training
        • BPM Practice
        • Distance Learning
        • ITIL Certification
        • Linux Certification Training
        • Media Security Solutions
        • Microsoft 365
        • Microsoft Official Courses On Demand
        • Microsoft Professional Program
        • NetApp Training
        • NIST Cybersecurity Framework
        • Salesforce Training
        • Training Facilities
        • Visual Studio TFS Training
        • Enterprise Training Solutions
        • Room Rentals
        • State & Local Government
      • Student Resources
        • Navigating Babbage Simmel Academy Courses
        • Ohio Workforce Training Voucher Program
        • Student Guide / Daily Schedule
        • College Credits / Tuition Reimbursement
        • Career Programs (WIA)
        • Student Policies
        • Testing & Certifications
        • Promotions
        • Local Hotels
        • Local Restaurants
      • Microsoft Access 2016 Level 1

      Course Details

      Download PDF
      M-AC16L1
      1 Days
      $ 295.00
      Request a Course Date

      Microsoft Access 2016 Level 1

      Share this course

      Tweet Share

      ​In Access 2016 Level 1 students learn the basic skills and concepts needed to use Microsoft Access 2016 productively and efficiently. Topics covered include reviewing the Access 2016 environment, effectively planning databases, creating tables, organizing fields and records, and working with data entry rules. Students will also learn how to create basic queries, and how to work with forms and reports.

      • Course Outline
      • Audience

      Course Outline

      Lesson 1:  Getting Started with Access 2016

      • Identify the Elements of the User Interface
      • Identify the Tabs and Commands on the Ribbon
      • Obtain Help in Access

      Lesson 2: Identifying the Components of a Database

      • Define Database Concepts
      • Identify the Components of a Database
      • Examine the Relational Database Design Process

      Lesson 3: Organizing Data in Tables

      • Create a Table
      • Modify Table Data and Properties
      • Create a Table Relationship

      Lesson 4: Fields and Records

      • Changing the design of a table
      • Finding and Editing Records
      • Organizing records

      Lesson 5: Data Entry rules

      • Setting Field Properties
      • Working with Input Masks
      • Setting Validation Rules

      Lesson 6: Basic queries

      • Creating and Using Queries
      • Modifying Query Results and Queries
      • Performing Operations in Queries

      Lesson 7: Using Forms

      • Creating Forms
      • Using Design View
      • Sorting and Filtering Records

      Audience

      ​This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. This Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. To be successful in this course, students should have a basic understanding of the Windows operating system, including how to launch an application and create and save files. Some knowledge of basic database concepts is also helpful.

      Related Courses

      Microsoft Access 2016 Level 2...

      ​You will learn to normalize data, join tables while observing referential int...

      View course details

      Microsoft Access 2016 Level 3...

      ​In Microsoft Access 2016 Level 3 students will learn advanced features of Acc...

      View course details

      Microsoft Excel 2016 Level 1...

      ​Microsoft Excel 2016 is the most widely accepted spreadsheet tool available t...

      View course details

      Microsoft Excel 2016 Level 2...

      Students taking the Intermediate Excel course will work with large worksheets in...

      View course details

      Microsoft Excel 2016 Level 3...

      You will work with advanced functions and formulas, as well as lookup functions ...

      View course details

      Microsoft PowerPoint 2016 Level 1...

      ​Microsoft PowerPoint 2016 can take any presentation from average to extraordi...

      View course details

      Microsoft PowerPoint 2016 Level 2...

      Students taking the Advanced PowerPoint course will learn to control global sett...

      View course details

      Microsoft Word 2016 Level 1...

      ​In Word 2016 Level 1 students will learn all the basics they need to create, ...

      View course details

      Microsoft Word 2016 Level 2...

      Now that you have mastered the basics of creating, editing and formatting docume...

      View course details

      Microsoft Word 2016 Level 3...

      Microsoft Word 2016 enables users to do far more than simple word processing. Wo...

      View course details

      College Credit, CEUs, PDUs and CDUs
      When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

      College Credit
      Select curriculum offered by Babbage Simmel is part of the accredited Ashland University undergraduate course catalogs. For questions please E-Mail: info@babsim.com or call 614-481-4345.

      Continuing Education Units (CEUs)
      Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: info@babsim.com or call 614-481-4345.

      Professional Development Units (PDUs)
      Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.

      Continuing Development Units (CDUs)
      CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.

      Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.

      About Us Contact Us Blog Find A Course

      © Copyright 2019 • Babbage Simmel. All Rights Reserved. Columbus Web Design by Jetpack | Privacy Policy