Microsoft Access 2010 Training - Beginners/Intermediate

Upgrading your Microsoft Access skills is a smart move for any professional.
4.6 (45 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
2,210 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 33
  • Length 10 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2012 English

Course Description

Learn Microsoft Access 2010 by Simon Sez IT is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Your professional trainer will introduce you to Microsoft’s “Ribbon” interface, showing you tips and techniques to leverage its features for more efficient database management.

Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier.

Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports.

Before the “Microsoft Access Training: Microsoft Access Tutorial” course is over, we’ll cover all key areas of the program: custom queries using defined criteria, select queries, updating queries, appending queries, deleting queries, inner joins, outer joins, table queries, and mail merges.

Plus, when you sign up for our class, you’ll also get these 5 BONUSES in addition to the 40 online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. Downloadable & printable transcripts (over 130 searchable pages) – to give you another learning option, if you prefer reading but don’t have time to take notes.
  4. 7 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  5. A certificate of completion to tell everyone you've aced the course.

Where else can you find so many extra tools to help you master Access 2010?!?!

So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise!

All of our videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.

What our customers are saying:

"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"

- Lisa R., France.

So take this Microsoft Access training and learn from Microsoft Access tutorial.

What am I going to get from this course?

  • Learn the Access 2010 interface including the Backstage View, Ribbon Features, and Quick Access Toolbar.
  • Explore the fundamentals of a database including records, fields, table objects, relationships, and primary keys.
  • Discover techniques for creating forms that present data in a visual way.
  • Understand and set-up the expression builder.
  • Filter data in single and multiple columns in tables and forms.
  • Learn how to create reports.
  • Discover how to improve your report design, add existing fields, and how to group and sort right on the report.
  • Learn how to update the database quickly using update queries, append queries, and delete queries.

What is the target audience?

  • The course is intended for anyone new to database concepts and wishing to use Access 2010.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Chapter 1 - Getting to Know the Workspace
Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
Preview
15:38
IMPORTANT - Read this to ensure the best video quality!
Article
Start/Exit, Help Features, Shortcuts, Views, Templates
Preview
15:32
Course transcripts
138 pages
Access 2010 keyboard shortcuts
28 pages
MP3 audio files
Article
Section 2: Chapter 2 - Access Basics
Understanding Database Components
Preview
15:14
Introduction to Design of a Database
Preview
14:19
Introduction to Building a Database
13:27
Section 3: Chapter 3 - Tables
Creating Tables & Basic Setup of Relationships
Preview
15:25
Using Quick Parts to Setup New Table, Importing Spreadsheet
16:18
Entering Data Types into Tables
15:18
Changing Table Attributes, Copy, Rename, Delete Records
16:21
Table Structures
15:15
Table and Field Properties
15:55
Section 4: Chapter 4 - Forms
Course Review
00:43
Auto-Create Forms, Filtering & Searching
15:13
Types of Different Forms & Creating New
14:56
Improve Look, Style, & Feel of Forms
15:13
Adding Fields to Existing Form
15:58
Section 5: Chapter 5 - Expression Builder
Understanding and Setting Up the Expression Builder
14:58
Section 6: Chapter 6 - Conditional Formatting
Format Control on Forms/Reports
14:58
Section 7: Chapter 7 - Sorting and Filtering
Sorting Single & Multiple Columns; Filter One Field Data Records
15:33
Sorting & Filtering Data in Form View; Find & Replace in Forms
15:10
Section 8: Chapter 8 - Reports
Understanding Reports & Structure
Preview
15:24
Creating Reports; Using Print Preview to Check Report Outcome
15:35
Advanced Reporting; Formatting Reports
15:23
How to Improve Report Design, Add Existing Fields; Group/Sort
14:25
Section 9: Chapter 9 - Queries
Select Queries; Sorting; Defined Criteria
15:00
Change Fields wthin Query; Specifying Criteria for Numbers/Text
15:31
Update Queries; Append Queries; Delete Queries
15:56
Inner/Outer Joins; Make Table Queries; Mail Merge
16:27
Section 10: Chapter 10 - Security
Securing Database and Views; New Features
14:01
Section 11: Quiz
Assessment Test
35 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course