
Explore how this course guides you from why to use Access to mastering tables, queries, forms, reports, and macros, plus step-by-step migration from Excel to Access and data preparation.
Discover why Access is worth it for Excel users: move from static visuals to a flexible database where you can filter orders by date and instantly recreate monthly reports.
Compare Excel tables and Access tables by exploring fields and records, and switch between tabbed and overlapping window views to understand navigation, record addition, and basic table concepts.
Explore advanced filters in Microsoft Access, including toggle filters, filter by form and the advanced filter sort grid, using wildcards and or logic to refine criteria.
Create a new table in Access using table design, set a primary key with auto number, name fields without spaces, and define short text fields like first and last name.
Explore table properties by applying format and input mask to text fields like city and state, use the input mask wizard for phone numbers, and adjust currency and date formats.
Explore report view and layout view in Access, and learn to resize and align header and detail controls by selecting the label and text box together.
Modify the report design by resizing the detail area and creating a customer name field from first and last names. Use selection and alignment techniques and preview with print preview.
Master the properties box to format controls, apply borders and lines, use F4 to show or hide it, and set conditional formatting based on the order subtotal.
Learn to build select queries in Access using query design, base them on the customer table, and use the asterisk to pull all fields.
Learn how to use criteria in Access queries to filter records with and versus or logic, including example state and city criteria, quotes, and viewing results.
Learn to use formulas in query criteria in Access, applying greater than, greater than or equal to, and between to filter product data (code, price, quantity) in design view.
Use a parameter query to capture a start date and end date, and create a dynamic report title that shows the entered dates.
Set up date parameters in the orders by date query using between criteria, start and end date prompts, and test with view to run a linked date-range report.
Finish the report by updating the title to show dates and adding a date text box with a start date and end date formula, and review queries for Excel import.
Explore on-the-fly lookups for the city field, using a distinct list in a combo box powered by SQL, with not null criteria and unique value queries to speed data entry.
Learn to use top queries in Access, including unique values vs unique records, and sort by date or subtotal to extract key records.
Create a macro to automate updating order totals by deleting the subtotal table, creating the subtotal with queries, and updating the totals in Access after importing from Excel.
Learn to consolidate monthly Excel reports into a single dataset before importing into Access, ensuring consistent column headers and efficient table structure for a smooth migration.
Keep data as raw as possible, avoid storing calculated fields, and maintain a simple lookup table design to plan your database using update and total queries.
Use the database documenter to print table structures from Excel data, showing field names, data types, and sizes, with an optional compact half-page report for notes.
Visualize and connect tables with the relationships screen in Access to see your database structure. Create, edit, and remove links; optionally enforce referential integrity and print a relationship report.
Learn more than the basic structures in Access. Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses.
From a recent Student Review:
5 Stars - I finally have a grasp of Access and relational databases!
Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel.
Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan
You will build a strong foundation in Access by understanding the logic behind its structure:
Another Student Review:
5 Stars - Fantastic Course!
I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens
These Powerful Skills Will Skyrocket Your Value in the Marketplace!
By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity!
There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income!
From a Student Review:
"This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams
Content and Overview
All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for.
Even though there are many lectures and several hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build your understanding of Access, one step at a time.
By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately, putting your new learned skills into practical use and impressing your boss and coworkers.
The course is complete with working files and finished samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.
Click the Take This Course button to take your first step towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!
From Another Student Review:
5 Stars - Absolutely the Best Course I Have Taken
I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron.
The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time.
The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career.
Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson
Another Student Review:
5 Stars - Brilliant piece of work!
Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification.
Brilliant Bruce, thanks again - Steven Kawuma
Required Software
You should have Office 2010 or later. The course was created using Office 2013.