Take this
course

Office Productivity / Microsoft

Access 2016 Intermediate

Take your Access 2016 skills to the next level. Learn how to design tables, use action queries, and more.

Description

This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2016 Advanced course.


Instructor: Ed McCrae

Full details

Curriculum

  • Introduction
    Introduction
    0:54
    Course Exercise Files
  • Designing Tables for Better Data Entry
    Reviewing Table Design Principles
    3:40
    Setting Field Size, Formats and Captions
    5:34
    Setting Default Value and Required Fields
    2:59
    Restricting Data Entry: Data Validation
    2:07
    Restricting Data Entry: Input Masks
    6:15
  • Sharing Data with Other Applications
    Exporting Tables and Queries to Excel
    2:50
    Importing Data from a TXT File
    2:52
    Importing Data from Excel
    2:13
    Exporting Data to a TXT File
    1:32
    Linking External Data Sources
    2:44
    Using Word Merge
    1:44
  • Working with Action Queries
    What are Action Queries?
    1:51
    Creating an Update Query
    2:28
    Creating an Append Query
    2:56
    Creating a Delete Query
    1:48
    Creating a Make Table Query
    1:40
    Changing the Start Number of an Auto Number Field
    3:10
  • Advanced Query Techniques
    Creating Query Joins
    5:14
    Creating Find Unmatached and Find Duplicate Queries
    2:47
    Creating Parameter Queries
    3:47
    Using Like Keyword in Parameter Queries
    2:14
    Creating a Top X Query
    1:23
    Reviewing Calculated Query Fields
    2:44
    Summarizing Query Data with Totals
    2:25
    Inserting WHERE Statements in Summary Queries
    1:03
    Creating a Crosstab Query
    2:46
  • Automating Processes with Macros
    Understanding Macro Basics
    5:45
    Creating Macros to Open Forms by Record
    4:06
    Validating Data Entry with Macros
    4:26
    Creating a Macro to Automate Data Entry
    3:32
    Advanced Data Entry Using Macros and DLOOKUP Functions
    5:49
  • Advanced Form Techniques
    Using Conditional Formatting
    1:34
    Organizing Form Fields with Tab Controls
    3:18
    Creating a Combo Box Control
    2:07
    Creating an Option Group Control
    2:49
    Using a Subform to Show Data from a Related Table
    2:49
  • Advanced Report Techniques
    Inserting a Chart on a Report
    3:18
    Showing Data in Columns
    1:38
    Inserting a Subreport
    2:12
    Configuring Reports with Parameter Queries
    3:50
    Sending Reports
    1:39
  • Conclusion
    Course Recap
    0:56

Skills

  • Microsoft Access

Similar Courses

More Courses by this Instructor