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 Life Purpose Meditation Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter iOS Development Android 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 Google Analytics
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Online Business Business Strategy Business Plan Startup Blogging Freelancing 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

Mastering Microsoft Access 2010 Made Easy Training Tutorial

Learn Introductory through Advanced material with this complete Access course. Video lessons & manuals included.
Rating: 3.1 out of 53.1 (4 ratings)
47 students
Created by TeachUcomp, Inc.
Published 1/2013
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Video Lessons
  • Includes Three Classroom Instruction Manuals
  • Creating Relational Database Tables
  • Advanced Queries
  • Form & Report Controls
  • Reports
  • Charting Data
  • Macros
  • Much More!

Requirements

  • Access software recommended for practice.

Description

Learn Microsoft Access 2010 with this comprehensive course from TeachUcomp, Inc. Mastering Access Made Easy features 102 video lessons with over 8 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn all about relational databases, advanced queries, creating forms, reporting, macros and much more.

Whether you are completely new to Access or upgrading from an older version, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Simply launch a video lesson or open one of the manuals and you’re on your way to mastering Access.

Who this course is for:

  • Anyone wanting to learn Microsoft Access.

Course content

20 sections • 105 lectures • 7h 55m total length

  • Preview02:35
  • Preview01:50
  • Preview01:55
  • Opening and Closing Databases
    01:33
  • Database Objects
    04:55

  • Preview01:27
  • Preview01:01
  • The "Flat-File" Model of Data Storage
    06:18
  • The Relational Model of Data Storage
    14:21
  • Tips for Creating a Relational Database
    04:07
  • Creating Relational Database Tables
    06:52
  • Assigning a Primary Key to a Table
    02:09

  • Preview01:14
  • Preview01:51
  • Preview01:10
  • Editing and Deleting Records in Datasheet View
    01:34
  • Inserting New Fields
    01:57
  • Renaming Fields
    01:19
  • Deleting Fields
    01:10

  • Preview01:34
  • Preview01:40
  • The 'Format' Property for Date/Time Fields
    01:11
  • The 'Format' Property for Logical Fields
    00:48
  • Setting Default Values for Fields
    01:31
  • Setting Input Masks
    01:55
  • Setting Up Validation Rules and Responses
    02:48
  • Requiring Field Input
    00:28
  • Allowing Zero Length Entries
    00:35

  • The Relationships Window
    04:15
  • Enforcing Referential Integrity
    05:18
  • Creating Lookup Fields
    04:27

  • Indexes
    03:02
  • Creating Indexes
    02:34
  • Deleting Indexes
    00:57

  • Using the Simple Query Wizard
    04:15
  • Designing Queries
    08:15
  • Joining Tables in a Query
    02:03
  • Adding Criteria to the QBE Grid
    01:00
  • Running A Query
    01:02
  • How is Using the QBE Grid Writing SQL Code?
    00:59
  • Sorting Query Results
    01:56
  • Hiding Fields in a Query
    00:59
  • Using Comparison Operators
    02:31
  • Using 'AND' and 'OR' Conditions
    03:46

  • Using the 'BETWEEN...AND' Condition
    01:36
  • Using Wildcard Characters in Criteria
    01:32
  • Creating a Calculated Field
    02:40
  • Creating 'Top Value' Queries
    02:05
  • Function Queries
    02:24
  • Parameter Queries
    03:48

  • Make-Table Queries
    03:18
  • Update Queries
    05:02
  • Append Queries
    04:14
  • Delete Queries
    02:04
  • Crosstab Queries
    03:30
  • The 'Find Duplicates' Query
    05:36
  • The 'Find Unmatched' Query
    03:11

  • Forms Overview
    01:08
  • The Form Wizard
    02:17
  • Creating Forms
    02:30
  • Using Forms
    01:08
  • Form and Report Layout View
    01:52
  • Form and Report Design View
    01:59
  • Viewing the Ruler and Grid
    01:20
  • The "Snap to Grid" Feature
    01:18
  • Creating a Form in Design View
    03:14

Instructor

TeachUcomp, Inc.
Quality Software Training
TeachUcomp, Inc.
  • 4.3 Instructor Rating
  • 19,634 Reviews
  • 261,664 Students
  • 85 Courses

Founded in 2001, TeachUcomp, Inc. began as a licensed software training center in Holt, Michigan - providing instructor-led, classroom-style instruction in over 85 different classes, including Microsoft Office, QuickBooks, Peachtree and web design, teaching staff at organizations such as the American Red Cross, Public School Systems and the Small Business Association.

At TeachUcomp, Inc., we realize that small business software can be confusing, to say the least. However, finding quality training can be a challenge. TeachUcomp, Inc. has changed all that. As the industry leader in training small business software, TeachUcomp, Inc. has revolutionized computer training and will teach you the skills to become a powerful and proficient user.

In 2002, responding to the demand for high-quality training materials that provide more flexibility than classroom training, TeachUcomp, Inc. launched our first product - Mastering QuickBooks Made Easy. The enormous success of our first tutorial led to an ever-expanding product line. TeachUcomp, Inc. now proudly serves customers in over 80 different countries world-wide including individuals, small businesses, non-profits and many others. Clients include the Transportation Security Administration, NASA, Smithsonian Institution, University of Michigan, Merrill Lynch, Sprint, U.S. Army, Oracle Corporation, Hewlett-Packard and the U.S. Senate.

Our full-time staff of software training professionals have developed a product line that is the perfect solution for busy individuals. Our comprehensive tutorials cover all of the same material as our classroom trainings. Broken into individual lessons, you can target your training to meet your needs - choosing just the lessons you want (and having the option to watch them all if you like). Our tutorials are also incredibly easy to use.

You will listen and watch as our expert instructors walk you through each lesson step-by-step. Our tutorials also feature the same instruction manuals (in PDF) that our classroom students receive - and include practice exercises and keyboard shortcuts. You will see each function performed just as if the instructor were at your computer. After the lesson has finished, you then "toggle" into the application and practice what you've learned - making it the most effective interactive training solution to learn on your own.

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