What you'll 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 - Encrypting the Database with a Password
Requirements
- Some of the lessons are quite technical, so you MUST have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Description
MODULE 1: Advanced Data Management
Learning 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 Integrity
Table Relationships
An Introduction to SQL
Modal Dialog Boxes
MODULE 2: Advanced Form Tasks
Learning 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 Subforms
Creating a Navigation Form
Advanced Form Controls
Exporting a Form
Other Form Tasks
MODULE 3: Automating Reports
Learning 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 Form
Building Query Criteria
MODULE 4: SQL and Microsoft Access
Learning outcomes: Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.
Topics covered:
Understanding SQL
Using the SELECT Statement
Using Subqueries
Using SQL Joins
MODULE 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 Basics
More about Macros
Access and VBA
Building Advanced Procedures
Using VBA in a Database
MODULE 6: Finishing the Application
Learning 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 Options
Sharing/Splitting the Database
Creating an ACCDE
Encrypting the Database with a Password
Who 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.
Instructor
The team at ZandaX provides English language online courses for personal development, management and Microsoft software. 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 management skills course creators are professionals with years of experience in the role, and have progressed through the ranks from novice supervisors through to senior management and director roles. Because of this, the courses give you clear, concise and knowledgeable advice, with proven techniques for success.
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 instead." He meant that it's harder to be brief, to distill messages to their core. But it's worth the effort, and we work hard so you can be spared the job of having to do it yourself.
And each course comes with workbooks and exercises that help you to take your learning as far as you need. We want you to improve your skills, and we give you the tools to do just that.
This means that when you buy one of our courses, you'll see that every one is thoroughly researched, but it's also concise and easy-to-follow too. There's no padding or time wasted.
You'll also see that our courses are 100% original: we take the best of others, add our own ideas, then build them from scratch. You'll only get a ZandaX course from ZandaX!
So try us and see: we're sure you'll love what we do!