Microsoft Access 2013 - Intermediate

Learn to Master Microsoft Access In Easy To Follow Step-By-Step Training
Course Created by Christine
Dr Christine has a BSc Computer Science and a Masters in Computer Science from University of Wollongong, Australia. She also has a PhD in the area of Intelligent Tutoring Systems from University of Malaya. She is currently the Deputy Head of School of Engineering and Computing at one of the leading colleges in Malaysia. Her passion and expertise is in Java Programming, Software Design and Implementation (C++), Visual Programming, Security Technologies and Artificial Intelligence. She has travelled to United Kingdom and Hong Kong to present at Conferences. In September 2014, she was invited by NCC Education, United Kingdom to conduct the Teacher Standardization Event in Myanmar.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

In this Microsoft Access 2013 (Intermediate) Training, your instructor, Christine, will lead you step-by-step in getting to the more advance usage of the program.

You will learn to import data, work with fields, expression builder and queries. You will also gain knowledge in working with forms and reports.

Check out our Course Outline for a more comprehensive listing of topics covered!

31 Videos (over 120 minutes of video content)

Why you should learn from this course?

  • Easy to follow and understand tutorials
  • Step-by-step detailed instructions
  • Hands on examples
  • Taught by an excellent instructor

Course Objectives

  • To learn Access beyond the basics of a simple database program
  • To empower Access users to harness the capability of the software beyond the basic level
  • To turn casual Access users to Power users

Who Is This For?

  • Casual Access users who wants to learn more about what Microsoft Access is capable of
  • Power users who wants to master Access further
  • Professionals who uses Access in their work constantly

Course Outline

Chapter 1: Working with Fields and Expression Builder

  • Lesson 1
    Importing & Exporting
    08:53
  • Lesson 2
    Importing into an Existing …
    02:33
  • Lesson 3
    Creating Primary Keys
    04:32
  • Lesson 4
    Converting Field Types
    04:51
  • Lesson 5
    Applying Custom Display For…
    04:07
  • Lesson 6
    Creating Input Mask
    06:41
  • Lesson 7
    Using the Lookup Wizard
    07:44
  • Lesson 8
    Assigning a Caption
    01:42
  • Lesson 9
    Setting Default Values
    04:01
  • Lesson 10
    Creating Validation Rules
    04:23
  • Lesson 11
    Miscellaneous Properties
    03:23

Chapter 2: Working with Queries

  • Lesson 12
    Querying Tables
    07:01
  • Lesson 13
    Modifying a Query
    05:11
  • Lesson 14
    Saving or Opening a Query
    01:41
  • Lesson 15
    Using Wildcards in Queries
    02:41
  • Lesson 16
    Compound Queries
    04:21
  • Lesson 17
    Miscellaneous Operators
    03:17
  • Lesson 18
    Creating Calculated Fields
    02:59
  • Lesson 19
    Using Substrings
    02:40
  • Lesson 20
    Using Summary Operators
    04:13
  • Lesson 21
    Querying Multiple Tables
    02:40
  • Lesson 22
    Using Action Queries
    07:44
  • Lesson 23
    Creating Permanent Relation…
    04:07

Chapter 3: Working with Reports

  • Lesson 24
    Creating Reports
    10:44
  • Lesson 25
    Printing Reports
    02:18
  • Lesson 26
    Saving & Opening Reports
    11:34
  • Lesson 27
    Close and Open Reports
    00:25

Chapter 4: Working with Forms

  • Lesson 28
    Creating Forms
    05:46
  • Lesson 29
    Customizing the Forms
    09:58
  • Lesson 30
    Saving or Opening Forms
    01:10

Chapter 5: File Properties

  • Lesson 31
    Setting File Properties
    03:16

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)