» » Microsoft Access Intermediate

Microsoft Access Intermediate

Microsoft Access Intermediate
Microsoft Access Intermediate
.MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 1.48 GB
Duration: 2.5 hours | Genre: eLearning Video | Language: English

Adding Functionality to your Databases Using Tables, Forms, Reports and Queries

What you'll learn

Requirements

Description

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

Using Windows Explorer within Access


What you'll learn
This training course has been designed to give delegates a solid understanding of more advanced tools and concepts for Access in order to increase their knowledge and productivity.
Requirements
Delegates 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 MS Access 2007, 2010, 2013 or 2016 who want to consolidate and expand on their knowledge of the basic features in a short space of time.
DOWNLOAD
(Buy premium account for maximum speed and resuming ability)