Microsoft Access Advanced (Udemy.com)

Learning to use MS Access to its Fullest Extent

Created by: ZandaX Training

Produced in 2019

icon
What you will learn

  • Main subject modules for our Microsoft Access Advanced course:
  • Advanced Data Management - Advanced Form Tasks - Automating Reports
  • SQL and Microsoft Access - Macros and Visual Basic for Applications (VBA) - Finishing the Application
  • Full module details:
  • Advanced Data Management - Referential Integrity - Table Relationships - An Introduction to SQL - Modal Dialog Boxes
  • Advanced Form Tasks - Using Subforms - Creating a Navigation Form - Advanced Form Controls - Exporting a Form - Other Form Tasks
  • Automating Reports - Creating the Report Form - Building Query Criteria
  • SQL and Microsoft Access - Understanding SQL - Using the SELECT Statement - Using Subqueries - Using SQL Joins
  • Macros and Visual Basic for Applications (VBA) - Access and VBA - Building Advanced Procedures - Using VBA in a Database
  • Finishing the Application - Setting Start Up Options - Sharing/Splitting the Database - Creating an ACCDE - Encrypt

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 74 / 100

icon
Course Description

MODULE 1: Advanced Data ManagementLearning outcomes: A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database. Topics covered: Referential IntegrityTable RelationshipsAn Introduction to SQLModal Dialog BoxesMODULE 2: Advanced Form TasksLearning outcomes: Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface. Topics covered: Using SubformsCreating a Navigation FormAdvanced Form ControlsExporting a FormOther Form TasksMODULE 3: Automating ReportsLearning outcomes: Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form. Topics covered: Creating the Report FormBuilding Query CriteriaMODULE 4: SQL and Microsoft AccessLearning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries. Topics covered: Understanding SQLUsing the SELECT StatementUsing SubqueriesUsing SQL JoinsMODULE 5: Macros and Visual Basic for Applications (VBA)Learning outcomes: Using Macros and Visual Basic to create some advanced functionality to your Access Database. Topics covered: Macro BasicsMore about MacrosAccess and VBABuilding Advanced ProceduresUsing VBA in a DatabaseMODULE 6: Finishing the ApplicationLearning outcomes: Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password. Topics covered: Setting Start Up OptionsSharing/Splitting the DatabaseCreating an ACCDEEncrypting the Database with a PasswordWho this course is for:
Users with a solid understanding of MS Access who want to take their capabilities to an advanced level in a short space of time.

icon
Instructor Details

ZandaX Training

I'm Steve Warren, and I head up the team at ZandaX, where we provide English language online courses for personal development and Microsoft software. But it's my team here that make things work as well as they do. We share a passion for getting results, and our reason for working is simple: to help people to improve their skills - and their lives too ...
The development team here have many years of training industry experience, both in classroom and virtual environments, so they know what you need in a course to be able to get the most from it.
Our Microsoft instructors don't just know the software: they've used it commercially and taught it in a classroom environment. You won't be in better hands.
Our business and soft skills presenters have been chosen for their clarity and professionalism in getting the message across. You'll be engaged as well as educated.
Our ethos is to provide courses that are comprehensive but compact, where you can get all you need in a manageable time. We feel that too many online courses today aren't focused. They often say so much that it's hard to find the important stuff. Who wants to sit through 20 hours of chat that takes forever to get to the point, when what you need can be covered in a targeted, structured course?
Remember Mark Twain, who said "I didn't have time to write a short letter, so I wrote a long one

icon
More courses by ZandaX Training

Microsoft Excel Advanced: the Data Analysis Tools You Need

$11.99

Microsoft Word Advanced

$11.99

icon
More office productivity courses

MS-700 Managing Microsoft Teams Training & Lab Simulations

$11.99

How to Create Animated Videos with Powerpoint

$11.99

Microsoft PowerPoint From Beginner to Advanced

$11.99

Productivity Hacks for Writers (Writing Mastery)

$11.99

Powerpoint 2016 2019 - Master powerpoint presentation

$11.99

Master Microsoft Word Beginner to Advanced

$11.99

icon
Reviews

3.7

6 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Asad Ahmed on 11/15/2020

You need to create one database and only 1 database to use for this entire class. Its very confusing to be moving around with different databases. I had a great deal of trouble following along with the other lectures.

By David Charlton on 11/15/2020

The advanced course increased my knowledge of the course. There is a fair amount to review but overall I am sure that my ability on access will be improved. A good investment to have taken the course.

By Merinda on 7/24/2020

This last video (Automating Reports) did not have sound?

By Swati Kamat on 2/18/2020

It is really good course for beginner, has covered almost all topics in brief

By Michael Calco on 10/3/2019

It really should be called "An Introduction to Advanced Access Features."

By John Boddington on 4/7/2019

Can't wait to try creating a database!