Learn the basics of Access, increase productivity, and acquire beginner to advanced skills in this Microsoft Access course.
Read more.Instructor
Hello, my name is Bruce. I am a self-employed Access programmer and general computer consultant to small and medium-sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long-term relationships with local businesses. Many of the sy
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseCourse Curriculum
Section 1 - THREE Major Data Problems That Access Completely Resolves | |||
Bruce’s Intro And Three Data Problems Overview | 00:00:00 | ||
Access Solves The SIZE And SPEED Problem | 00:00:00 | ||
Access Solves The DATA SHARING Problem | 00:00:00 | ||
Access Solves The ONE To MANY Problem | 00:00:00 | ||
Section 2 - Learning The Parts Of The Access Screen | |||
The Parts Of The Access Screen | 00:00:00 | ||
Direct Download Of Database File | 00:00:00 | ||
Working With The Navigation Pane, Menu, Ribbons And Objects | 00:00:00 | ||
Section 3 - TABLE Objects - The Basics | |||
Creating Our First Table And Data Type PDF | 00:00:00 | ||
Adding, Editing And Deleting Records | 00:00:00 | ||
Primary Keys: What They Are And Why They Are Important | 00:00:00 | ||
Adding Autonumbers, Primary Keys And Restructuring Tables | 00:00:00 | ||
Basic Table Sorting And Filtering | 00:00:00 | ||
Section 4 - REPORT Objects - The Basics | |||
What Do Reports Do? | 00:00:00 | ||
Modifying The Report | 00:00:00 | ||
Working With Controls, Report And Layout Views | 00:00:00 | ||
Section 5 - QUERY Objects: The Basics | |||
Basic Queries | 00:00:00 | ||
Query Criteria | 00:00:00 | ||
Date Criteria And Between | 00:00:00 | ||
Using OR In Criteria | 00:00:00 | ||
Parameter Queries | 00:00:00 | ||
Section 6 - PROPERTIES: Making Thousands Of Choices Manageable | |||
Viewing Table Properties And Custom Formatting PDF | 00:00:00 | ||
Field Validation And Other Field Properties | 00:00:00 | ||
Query Properties | 00:00:00 | ||
Report Properties | 00:00:00 | ||
Section 7 - FORM Objects - The Basics | |||
Creating A Form With The Wizard | 00:00:00 | ||
Cleaning Up the Form – Working With Controls | 00:00:00 | ||
More Form Cleanup – Moving Labels, Adding Rectangles, Font Color | 00:00:00 | ||
Resize Header And Detail And Finish Form | 00:00:00 | ||
Section 8 - Advanced TABLES | |||
Using The Lookup Wizard | 00:00:00 | ||
Setup Lookups Without The Wizard | 00:00:00 | ||
Advanced Sorting And Filtering | 00:00:00 | ||
Working With Related TABLES | 00:00:00 | ||
Section 9 - Advanced QUERIES | |||
Using TOP Queries | 00:00:00 | ||
Using TOTAL Queries | 00:00:00 | ||
ACTION Queries – UPDATE | 00:00:00 | ||
ACTION Queries – APPEND | 00:00:00 | ||
Multi Table And MAKE TABLE ACTION Queries | 00:00:00 | ||
ACTION Queries – DELETE | 00:00:00 | ||
Calculations In Queries And Formatting Results | 00:00:00 | ||
A Parameter Query Trick | 00:00:00 | ||
Section 10 - Advanced REPORTS | |||
Reports Based On The Parameter Query Trick | 00:00:00 | ||
Calculations In Reports | 00:00:00 | ||
Sorting With Reports | 00:00:00 | ||
Adding An Order Month To Our Query | 00:00:00 | ||
Subtotals In Reports | 00:00:00 | ||
Label The Subtotals And Report Total | 00:00:00 | ||
Conditional Formatting | 00:00:00 | ||
Section 11 - Advanced FORMS | |||
Add A Combo Box To Our Orders Form | 00:00:00 | ||
Setting The Tab Order | 00:00:00 | ||
Using TAB Controls | 00:00:00 | ||
Continuous Forms 1 – Add A Calculated Field | 00:00:00 | ||
Continuous Forms 2 – A Shortcut For Creating | 00:00:00 | ||
Add A Subform | 00:00:00 | ||
Change A Textbox Into A ComboBox | 00:00:00 | ||
Section 12 - Automating Things In Your Forms | |||
The Hooks – Form And Report EVENT Properties | 00:00:00 | ||
Updating The Main Form Total | 00:00:00 | ||
Recalculating The Order Total | 00:00:00 | ||
Section 13 - More Form Automation: BUTTONS And MACROS | |||
Create A Go To Customer Button | 00:00:00 | ||
Create A To Orders button In A Subform | 00:00:00 | ||
A New Order Button On The Customer Form | 00:00:00 | ||
Modify The Add Order Macro To Plug The Name And Address | 00:00:00 | ||
New Customer And Exit Buttons | 00:00:00 | ||
A Special Startup Macro | 00:00:00 | ||
Section 14 - Creating A Multi Page Invoice | |||
Create An Invoice Report From The Orders Subform | 00:00:00 | ||
Change Invoice Recordsource And More Formatting | 00:00:00 | ||
Create An Invoice Button On The Orders Form | 00:00:00 | ||
Test A Multi Page Invoice And Final Formatting | 00:00:00 | ||
Section 15 - Final Thoughts | |||
Access Is Built For Networking | 00:00:00 | ||
THREE Best Practices In Table Design With PDF | 00:00:00 | ||
What’s New In Access 2016 | 00:00:00 |