Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
11 Hour(s) 40 Minute(s)
Language
English
Taught by
IsáBel .
Rating
Course Overview
Don't Miss This Info Packed Three-Course Bundle: (1) Customizing Your Database (2) Automate w/Macros (3) SQL Scripting
Microsoft Access Three Course Bundle:
→ Access: Customizing Tables, Forms, Reports & Action Queries
→ Microsoft Access Macros: Automate Your Access Database
→ Microsoft Access SQL: SQL for Non-Programmers
So, what's in this course for you?
:: Access Customizing Skills & Strategies ::
↳ Learning Microsoft Access tips will absolutely make your workday easier.
From importing and exporting data with Microsoft Excel, to restricting data that is entered into your tables.
Create cascading combo boxes that display information based off of data in another combo box.
You'll also find pro tips on using reports, and queries, documenting your database, and simplifying navigation.
:: Creating Macros for Saving Time ::
↳ Learn to create Macros for more control over the database, get work done faster, and feel efficient.
You don't need to know any VBA code, you just need a willingness to want to save time with macros, to upgrade your skills, and to invest a few hours of time in the process.
:: Learning How SQL Can Interact with Your Database ::
↳ This week you can start learning SQL, step by step, and improve your skills.
Learn to use SQL in your Access databases from the beginning. Select data, as well as filter, and sort. Learn to create table, and about joins. No prior SQL experience required.
This bundled course can be completed in hours, but the information can last a lifetime.
So if you are beyond the basic beginner stage in Access, and want a convenient way to learn, I invite you to enroll.
This is not an advanced Access course, though advanced users are welcome, and might benefit from lectures within the course.
Take a look at the course curriculum to help decide if this informative, easy-to-follow course is for you.
You only have MICROSOFT ACCESS DATABASE SKILLS to gain.
So Click The Take
This Course Button On The Right
and become a better Microsoft Access User.
Course Content
- 10 section(s)
- 186 lecture(s)
- Section 1 Latest Access Beyond the Basics Quick Tip
- Section 2 Welcome to Microsoft Access: Beyond the Basics of Access Bundle!
- Section 3 Access: Customizing Tables, Forms, Reports & Action Queries
- Section 4 Access Database Tables: Customizing Existing Tables
- Section 5 Access Database Forms: Adding More Functionality
- Section 6 Access Database Reports: Enhancing the Look & Feel
- Section 7 Access Database Queries: Parameter, Action, Cross Tab, and Self Join Queries
- Section 8 Access Database Start Up & Navigation: Customizing the User Interface
- Section 9 Access Database Maintenance
- Section 10 Additional Access Database Resources
What You’ll Learn
- This bundle combines 3 courses to help you conquer Access in weeks - not months or years (because who's got time for that?)
- Learn TIME-SAVING Database Tips, AUTOMATE Your Database with MACROS, and SCRIPT SQL all in one course!
- ----------
- ----------
- SET Field Validations. Make sure users are entering the correct data.
- IMPORT and EXPORT Data Using Microsoft Excel, an application you probably use daily.
- CREATE Cascading Combo Boxes. Base the items in a combo box off what was selected in another combo box.
- CONDITIONALLY FORMAT Forms & Reports to make your data easier to understand.
- CREATE Parameter & Action Queries. Go beyond standard Select Queries
- CUSTOMIZE the Access Environment Ribbon, Navigation Pane & Startup
- UNDERSTAND Database Maintenance Tools to keep your data intact.
- USE the Macro Builder Window to automate your database
- CREATE Data Macros for Table Automation
- CREATE Macros for Forms & Reports
- CREATE AutoExec Macros to run Macros when starting your database
- SCRIPT SQL to Query Your Tables
- CREATE Database Tables with SQL
- CREATE Table Joins with SQL
- CREATE Action Queries with SQL
- ... and so much more!
Skills covered in this course
Reviews
-
MMick Newing
It's a very well instructed course but some of the example tables etc used in the course I didn't have but still followed them. I have learnt a lot from this course, enough to give me different ideas to build a business database. You are an exceptional instructor and it is easy to follow. Thank you IsaBel.
-
AAllan R Caple
I found this course a little different to what I'm used to but, having said that, it was comprehensive and backed up with good resources.
-
SSuvadip Kundu
I checked out Udemy for a course on Access to recommend to colleagues with intermediate level Access proficiency so that they can use MS Access more productively at work. I chose this one after reviewing several as this has the best mix of 3 areas (the tools and tricks for doing more with tables, forms and reports; using Access Macros & SQL query build) that can boost productivity of an Access user considerably. What did I miss in the course? nothing really, if I am really nitpicking :), a accompanying section on VBA based Macros that can further the use of Access based applications would surely be a very welcome addition.
-
AAaron Starr
There is a great deal of good information in this course. Each lesson explains the subject in detail which gets repetitive when the subjects are similar. There are many examples (too many for the same thing, sometimes) but the examples are more academic than real world and the "big picture" is often lost in the details. I think this is an EXCELLENT reference and resource course for someone already versed in Access. The course is "Beyond the Basics;" and not the place to start.
