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

Microsoft Access 2010 Tutorial - Learn At Your Own Pace

A practical Microsoft Access 2010 tutorial that allows you to learn at your own pace using hands-on lessons.
Rating: 4.2 out of 54.2 (382 ratings)
5,483 students
Created by Infinite Skills
Published 5/2012
English
English [Auto]
30-Day Money-Back Guarantee

Description

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

This Microsoft Access 2010 training course offers a ground-up guide to form and database creation and management with this powerful office productivity tool. Narrated by teacher, author and technology trainer Robert Tucker, this beginner friendly course begins with the very basics and gradually builds to a level of professional proficiency every users should know. Starting with the user interface, the hands-on training takes you through the creation of a single table, then moves to field types and properties, creating input forms, generating reports, and all the associated functions you would expect to know in a business environment. As you move through the video tutorial, Robert even begins to cover some advanced features such as Crosstab Queries, importing data from multiple sources, join queries, and more. By the end of the MS Access course, you will be fully versed in the creation and use of Microsoft Access databases, and know how to get quickly get your data in and out.


What You Will Learn

- How to create professional quality user forms, databases and reports with one of the world's leading office productivity tools.
- How to manipulate and implement data and data sources across a wide range of projects.
- How to create secure, compatible databases that can be accessed by users working with Office products and common industry standards.

Who Should Take This Course

- Anyone who has used Microsoft Access in the past but wanted a better understanding of its full range of features.
- Anyone who needs an understanding of Microsoft Access software as it applies to a professional work or academic environment.
- Anyone new to MS Access wanting a user-friendly guide that introduces the program from the ground up.


What People Are Saying

"Probably the one program in the Office suite that was a little intimidating is now in reach. We're integrating our office's appointment system, and with these tutorials it's going great."
- Angela Card

"Beginners should not be afraid...I was nervous that this course might be too technical but the author is very direct and his examples are very easy to follow along with."
- Roy Metzger

Course content

15 sections • 112 lectures • 9h 43m total length

  • Preview00:42
  • Preview08:01
  • The New File Menu In Access 2010
    09:24
  • Making The Most Of The Navigation Pane
    07:12
  • Customize The Quick Access Toolbar
    04:28
  • Enable Content Using A Trusted Location
    03:32
  • Choose Between Tabbed Or Overlapping Windows
    04:26
  • Using The Files Included With This Course
    01:53
  • What Will I Be Able To Do At The End Of This Course
    03:27

  • What Constitutes A Database
    03:46
  • The Components That Make Up A Database
    02:18
  • Why Do We Need A Relational Database Like Access
    07:02
  • Creating A Database Using The Database Wizards
    06:45
  • Create A Database WITHOUT The Wizard (Recommended)
    03:31

  • Designing Then Creating A Single Table Database
    06:47
  • Using The Correct Data Types
    07:07
  • Managing The Each Fields Properties
    14:10
  • Adding Lookup Options To A Field
    05:01
  • Adding An Input Mask To Safeguard Data Entry
    04:09
  • Adding A Validation Rule To Safeguard Data Entry
    04:02
  • The New Calculated Field In Access 2010
    07:45
  • The Primary Key
    05:53
  • Entering Data Into A Table
    08:12
  • Sorting Data In A Table
    04:16
  • Deleting Records From A Table
    03:44
  • Editing Records In A Table
    04:58
  • Finding Records In A Table
    04:28
  • Find And Replace Field Values
    05:46
  • Filtering Table Data
    08:18

  • What Is A Query
    04:28
  • Creating Saving And Running A New Query
    06:28
  • CAREFUL Editing Data In A Query
    02:12
  • Changing The Design Of A Query
    03:29
  • Add Criteria To A Text Field To Filter Records
    04:24
  • Filtering A Query On A Number Field
    04:40
  • Using Date Filters In A Query
    05:25
  • Boolean Fields In Querying
    03:41
  • Adding Wildcards To Query Criteria
    07:04
  • Retrieving Empty Values With A Query (NULL)
    04:07
  • Selecting Using Different Criteria On The Same Field (OR)
    03:35
  • Selecting Using Different Criteria On Different Fields (AND)
    03:54
  • Sorting The Results Of A Query
    03:38
  • Hiding Filtering Columns From A Query Result
    02:07
  • Evaluating Calculations With Queries
    04:40
  • Working Out The Current Age Of Contacts
    05:01
  • Produce Totals Using An Access Query
    08:37
  • Finding Duplicate Records With A Query
    05:37

  • Creating A Form Using The Wizard
    05:56
  • Column Or Tabular Forms - Which To Choose
    02:54
  • Viewing And Editing Records Through A Form
    03:16
  • Adding Records Through Forms And Associated Problems
    04:11
  • Searching For Records In Forms
    04:18
  • Deleting A Record In A Form
    01:59
  • Sorting Records
    02:47
  • Applying Filters Within Forms
    05:03
  • Modifying The Design Of A Form
    07:58
  • Adding Fields Not Currently Displayed
    04:02
  • Aligning And Spacing Form Controls
    04:44
  • Amending The Tab Order
    03:43
  • Add Logos And Images
    03:38
  • Adding Todays Date
    03:47
  • Calculating Fields In Forms
    08:46

  • Creating A Basic Report Using The Wizard
    06:30
  • Grouped Reports Through The Wizard
    07:42
  • Basing A Report On A Query
    05:09
  • The Quick Report Tool
    04:03
  • Editing The Layout Of A Wizard Generated Report
    07:39
  • Printing Reports
    02:59
  • Creating A PDF From A Report
    05:11

  • How To Create A Multi Table Database
    06:56
  • Creating Links Between Tables
    06:24
  • What Is The Foreign Key
    01:18
  • Removing Or Editing A Relationship
    02:59
  • Referential Integrity
    05:50
  • Viewing And Editing Data In A Sub Datasheet
    04:21
  • Creating A Query That Extracts Data From More Than One Table At A Time
    07:44
  • Create A Form Based On A Multi Table Query
    02:46
  • Generating A Report Based On More Than One Table
    05:01

  • What Is Normalization
    03:19
  • Normalizing The Sample Database
    05:44

  • Importing Data Into Access From Excel
    06:42
  • Importing Data Into Access From Access
    02:59
  • Importing Data Into Access From Text Files
    04:21
  • Converting An Access 2010 Database To A Previous Version
    03:29
  • Making Use Of Lookups In Tables
    06:59
  • Why Do I Need To Index Fields In Tables
    08:25
  • Multiple Field Primary Keys
    04:34
  • Printing The Relationship Diagram
    03:22

  • Using More Than One Table To Feed A Query
    05:05
  • Changing The Join Type Of Links In Queries
    05:57
  • Watch Out For The Cartesian Join
    04:23
  • Parameter Queries
    07:44
  • Introducing The Crosstab Query
    08:29

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 117,450 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.