Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This Advanced Microsoft Access 2010 Tutorial Video picks up where the InfiniteSkills beginner course leaves off and shows how to work with some of the program's more robust database creation and management features. Presented by a professional IT trainer, the video lessons go point by point through advanced query options and form design, as well as a number of shortcuts and productivity options that can simplify and shift the way you work. Given the advanced subject matter, the order of the Access course is logical and easy to follow. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data, and the course's full chapter on Macros make it easy to manage and access data in Access 2010. Project files are included to match the examples onscreen.
What You Will Learn
- How to perform advanced data manipulation across multiple databases and sources.
- How to create complex user forms that will improve the quality and quantity of data collected.
- How to perform crucial management and maintenance functions using Access utilities and commands.
- How to enhance and develop secure, compatible databases that can be accessed by users working with Office products and common industry standards such as SQL.
Who Should Take This Course
- Anyone with a basic understanding of Microsoft Access who wants to unlock the program's power user capabilities and security features.
- Anyone who wants to implement Access solutions within SQL-based and mixed environments.
- Access administrators looking to work faster and smart through shortcuts and macros that automate repetitive tasks.
What People Are Saying
"I was told we'd have to move everything over to MySQL to get the security we needed, but these tutorials helped me prove otherwise. The lessons on encryption were perfect."
- Hank Mascis
"I am genuinely impressed with what is capable with Access now. It's improved greatly over the years, and this training and the VBA course has helped me see the light."
- V Spinotto
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started|
Working Files - Download These FirstPreview
What Will This Course CoverPreview
Relational Databases DemystifiedPreview
Using The Working Files
|Section 2: Advanced Table Design|
Creating And Using Input Masks
Indexing - The Hows And Whys
Multiple Field Primary Keys
|Section 3: Advanced Queries|
Selecting Unique Values
Use Of Parameter Queries
Adding A Calculated Field
Using iif In A Calculated Field
Creating A Cross Tab Query
A Cross Tab Without The Wizard
Why Change The Join Type In Queries
Viewing And Writing SQL
Introducing The Expression Builder
The Power Of The Sub Query
Generating A Union Query In Access
|Section 4: Action Queries|
The Make Table Query - For Backups
The Make Table Query From Multiple Tables Of Data
Changing Data Using An Update Query
Update Query With A User Driven Parameter
Add Records To A Table Using The Append Query
Delete Records Using The Delete Query
Backup And Restore Data Using Action Queries
|Section 5: Advanced Form Design|
Adding Linked Objects And Displaying On A Form
Sub Forms Unbound Or Bound
Using Tabs To Display Multiple Sub Form Data
Referencing Combo Box Unbound Columns
The NEW Navigation Forms
Creating A Form To Use As A Menu Or Dialog
Adding A Form Button With The Wizard
Creating Buttons WITHOUT The Wizard
Open Another Form-Filtered By Current Form (Method 1)
Open Another Form-Filtered By Current Form (Method 2)
Building A Search Form
Check Whether The Search Criteria Is Entered
Use Double Click To Open Related Data
Dynamically Changing The Row Source Of A Combo Or List Box
|Section 6: Advanced Reports|
Creating A Report From Scratch Without The Wizard
Adding Images To The Report
Calculations On A Report
Sorting And Grouping A Report
Totals On Reports Groups
Creating And Adding Sub Reports
Concatenation With Carriage Returns
Adding A Chart Or Graph
A Chart Filtered By The Report Section
Pie Charts In Reports
|Section 7: Macros|
Creating A New Macro
Example Functionality Of Macros
Assigning Macros To Buttons On Forms
Using if In A Macro To Control Program Flow
Commenting Your Macro Code For Future Reference
NEW - The Embedded Macro
Sub Macros And Their Uses
Trigger A Macro From The Ribbons
Controlling Startup Actions With The AutoExec Macro
Creating An AutoKeys Macro For Customizing Keyboard Shortcuts
Adding An OK/Cancel Confirmation Box
|Section 8: Database Utilities|
Compact And Repair - A Useful Utility
Converting Access To Previous Versions
Saving A Backup Copy
Tracking Object Dependencies
The Start Up Settings
|Section 9: Application Making And Security|
Main Menu Tidying Requirements
Restricted Access By Use Of The ACCDE Format
Download And Distribute Access 2010 Runtime
Encrypting And Password Protecting A 2010 Database
Splitting The Database In Two For Final Security
|Section 10: Access With SQL Server|
Upgrade An Existing Application To Use SQL Server
Linking a New Database To SQL Server
Introducing The Access Project File
Running A Stored Procedure From The Access Project
|Section 11: Summary|
What Have You Learned?
Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.
The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.