Microsoft Access Intermediate
2.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,362 students enrolled

Microsoft Access Intermediate

Adding Functionality to your Databases Using Tables, Forms, Reports and Queries
2.6 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,362 students enrolled
Created by ZandaX Training
Last updated 9/2019
English
English [Auto]
Current price: $97.99 Original price: $139.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Main subject modules for our Microsoft Access Intermediate course:
  • Advanced File Tasks - Working with Tables - Working with Forms
  • Working with Reports - Working with Queries
  • Full module details:
  • Advanced File Tasks - Using Windows Explorer within Access - Database Management - Saving Your Files - Exporting Files - Linking Files
  • Working with Tables - Customizing Tables - Table Properties: Formatting - More Table Properties - Data Validation and Lookup Wizard
  • Working with Forms - Basic Form Controls - Advanced Form Controls - Formatting Your Form - Formatting Controls - Using Themes
  • Working with Reports - Organizing Report Data - Formatting Reports - Common Report Tasks
  • Working with Queries - Basic Queries - Doing More with Queries - Creating Advanced Queries - Creating Management (Action) Queries
Requirements
  • You should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Description

MODULE 1:  Advanced File Tasks

Learning outcomes:  A look at some important administrative features necessary for managing an Access Database file.

Topics covered:

  • Using Windows Explorer within Access

  • Database Management

  • Saving Your Files

  • Exporting Files

  • Linking Files

MODULE 2:  Working with Tables

Learning outcomes:  Further developing an understanding of tables, looking deeper into a  table's properties fine tuning data types and use data validation.

Topics covered:

  • Customizing Tables

  • Table Properties: Formatting

  • More Table Properties

  • Data Validation and Lookup Wizard

MODULE 3:  Working with Forms

Learning outcomes: Building professional forms to enhance the user experience and improve effective use.

Topics covered:

  • Basic Form Controls

  • Advanced Form Controls

  • Formatting Your Form

  • Formatting Controls

  • Using Themes

MODULE 4:  Working with Reports

Learning outcomes:  Organize and format your reports professionally and common report tasks you may need to perform.

Topics covered:

  • Organizing Report Data

  • Formatting Reports

  • Common Report Tasks

MODULE 5:  Working with Queries

Learning outcomes:  Creating a range of different queries from very basic queries  through to management queries with advanced functionality.

Topics covered:

  • Basic Queries

  • Doing More with Queries

  • Creating Advanced Queries

  • Creating Management (Action) Queries

Who this course is for:
  • Users with a basic understanding of Microsoft Access who want to consolidate and expand on their knowledge of the basic features in a short space of time.
Course content
Expand all 48 lectures 02:39:59
+ Advanced File Tasks
11 lectures 34:46
Saving Your Files - Overview
01:04
Saving Your Files
06:30
Exporting Files - Overview
01:04
Exporting Files
06:43
Linking Files - Overview
01:22
Linking Files
05:50
+ Working with Tables
9 lectures 37:20
Introduction
00:37
Customizing Tables - Overview
00:43
Customizing Tables
07:43
Table Properties: Formatting - Overview
00:58
Table Properties: Formatting
11:55
More Table Properties - Overview
01:01
More Table Properties
08:22
Data Validation and Lookup Wizard - Overview
01:01
Data Validation and Lookup Wizard
05:00
+ Working with Forms
11 lectures 40:01
Introduction
00:44
Basic Form Controls - Overview
00:33
Basic Form Controls
04:39
Advanced Form Controls - Overview
00:53
Advanced Form Controls
05:33
Formatting Your Form - Overview
00:32
Formatting Your Form
14:35
Formatting Controls - Overview
00:33
Formatting Controls
06:30
Using Themes - Overview
00:49
Using Themes
04:40
+ Working with Reports
7 lectures 21:58
Introduction
00:39
Organizing Report Data - Overview
00:33
Organizing Report Data
05:37
Formatting Reports - Overview
00:26
Formatting Reports
06:13
Common Report Tasks - Overview
00:59
Common Report Tasks
07:31
+ Working with Queries
9 lectures 24:46
Introduction
01:23
Basic Queries - Overview
01:01
Basic Queries
03:31
Doing More with Queries - Overview
00:46
Doing More with Queries
03:56
Creating Advanced Queries - Overview
02:27
Creating Advanced Queries
04:55
Creating Management (Action) Queries - Overview
01:31
Creating Management (Action) Queries
05:16