Genre: eLearning | Language: English + .VTT | Duration: 2.5 hours | Size: 1.48 GB
What you'll learn Homepage: https://www.udemy.com/microsoft-access-intermediate/
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.
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.