Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Startup Business Plan Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Access

Advanced Microsoft Access 2010 Tutorial

Take your Microsoft Access skills to the next level with this Advance Access Tutorial.
Rating: 4.4 out of 54.4 (117 ratings)
1,819 students
Created by Infinite Skills
Last updated 1/2017
English
English [Auto]
30-Day Money-Back Guarantee

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

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

Course content

11 sections • 74 lectures • 7h 9m total length

  • Preview00:01
  • Preview02:41
  • Preview07:54
  • Using The Working Files
    04:12

  • Creating And Using Input Masks
    09:02
  • Indexing - The Hows And Whys
    07:31
  • Multiple Field Primary Keys
    02:48

  • Selecting Unique Values
    04:35
  • Use Of Parameter Queries
    07:35
  • Adding A Calculated Field
    05:35
  • Using iif In A Calculated Field
    04:45
  • Creating A Cross Tab Query
    05:19
  • A Cross Tab Without The Wizard
    03:31
  • Why Change The Join Type In Queries
    07:09
  • Viewing And Writing SQL
    07:50
  • Introducing The Expression Builder
    06:45
  • The Power Of The Sub Query
    06:47
  • Generating A Union Query In Access
    06:43

  • The Make Table Query - For Backups
    04:15
  • The Make Table Query From Multiple Tables Of Data
    05:22
  • Changing Data Using An Update Query
    07:06
  • Update Query With A User Driven Parameter
    03:53
  • Add Records To A Table Using The Append Query
    03:46
  • Delete Records Using The Delete Query
    03:51
  • Backup And Restore Data Using Action Queries
    07:08

  • Adding Linked Objects And Displaying On A Form
    07:01
  • Sub Forms Unbound Or Bound
    09:00
  • Using Tabs To Display Multiple Sub Form Data
    08:08
  • Referencing Combo Box Unbound Columns
    05:18
  • The NEW Navigation Forms
    04:25
  • Creating A Form To Use As A Menu Or Dialog
    04:01
  • Adding A Form Button With The Wizard
    08:07
  • Creating Buttons WITHOUT The Wizard
    08:37
  • Open Another Form-Filtered By Current Form (Method 1)
    08:04
  • Open Another Form-Filtered By Current Form (Method 2)
    06:56
  • Building A Search Form
    08:56
  • Check Whether The Search Criteria Is Entered
    07:34
  • Use Double Click To Open Related Data
    04:55
  • Dynamically Changing The Row Source Of A Combo Or List Box
    08:16

  • Creating A Report From Scratch Without The Wizard
    08:39
  • Adding Images To The Report
    04:21
  • Calculations On A Report
    03:39
  • Sorting And Grouping A Report
    10:09
  • Totals On Reports Groups
    06:25
  • Creating And Adding Sub Reports
    10:00
  • Concatenation With Carriage Returns
    08:30
  • Adding A Chart Or Graph
    06:21
  • A Chart Filtered By The Report Section
    06:00
  • Pie Charts In Reports
    08:29

  • Creating A New Macro
    04:10
  • Example Functionality Of Macros
    05:46
  • Assigning Macros To Buttons On Forms
    05:08
  • Using if In A Macro To Control Program Flow
    09:08
  • Commenting Your Macro Code For Future Reference
    02:48
  • NEW - The Embedded Macro
    05:01
  • Sub Macros And Their Uses
    06:16
  • Trigger A Macro From The Ribbons
    07:04
  • Controlling Startup Actions With The AutoExec Macro
    07:49
  • Creating An AutoKeys Macro For Customizing Keyboard Shortcuts
    06:25
  • Adding An OK/Cancel Confirmation Box
    04:31

  • Compact And Repair - A Useful Utility
    02:42
  • Converting Access To Previous Versions
    03:01
  • Saving A Backup Copy
    01:03
  • Tracking Object Dependencies
    04:04
  • The Start Up Settings
    05:19

  • Main Menu Tidying Requirements
    04:47
  • Restricted Access By Use Of The ACCDE Format
    03:56
  • Download And Distribute Access 2010 Runtime
    02:11
  • Splitting The Database In Two For Final Security
    07:59

  • Upgrade An Existing Application To Use SQL Server
    07:29
  • Linking a New Database To SQL Server
    06:37
  • Introducing The Access Project File
    07:21
  • Running A Stored Procedure From The Access Project
    05:28

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 117,431 Reviews
  • 1,232,211 Students
  • 327 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.