Microsoft Access 2010 Training – Beginners/Intermediate

Microsoft Access 2010 Training – Beginners/Intermediate, available at $54.99, has an average rating of 4.45, with 33 lectures, 1 quizzes, based on 94 reviews, and has 2331 subscribers.

You will learn about 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. This course is ideal for individuals who are The course is intended for anyone new to database concepts and wishing to use Access 2010. It is particularly useful for The course is intended for anyone new to database concepts and wishing to use Access 2010.

Enroll now: Microsoft Access 2010 Training – Beginners/Intermediate

Summary

Title: Microsoft Access 2010 Training – Beginners/Intermediate

Price: $54.99

Average Rating: 4.45

Number of Lectures: 33

Number of Quizzes: 1

Number of Published Lectures: 33

Number of Published Quizzes: 1

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: $64.99

Quality Status: approved

Status: Live

What You Will Learn

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.

Who Should Attend

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

Target Audiences

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

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 BONUSESin addition to the 40 online course videos:

Downloadable & printable keyboard shortcuts – to help you save time and get your work done faster.
An online quiz (40 questions) – to test what you've learned.
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.
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.
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.

Course Curriculum

Chapter 1: Chapter 1 – Getting to Know the Workspace

Lecture 1: Intro to Backstage View, Ribbon, Quick Access Toolbar & Options

Lecture 2: READ ME: Essential Information for a Successful Training Experience

Lecture 3: Start/Exit, Help Features, Shortcuts, Views, Templates

Lecture 4: Course transcripts

Lecture 5: Access 2010 keyboard shortcuts

Lecture 6: MP3 audio files

Chapter 2: Chapter 2 – Access Basics

Lecture 1: Understanding Database Components

Lecture 2: Introduction to Design of a Database

Lecture 3: Introduction to Building a Database

Chapter 3: Chapter 3 – Tables

Lecture 1: Creating Tables & Basic Setup of Relationships

Lecture 2: Using Quick Parts to Setup New Table, Importing Spreadsheet

Lecture 3: Entering Data Types into Tables

Lecture 4: Changing Table Attributes, Copy, Rename, Delete Records

Lecture 5: Table Structures

Lecture 6: Table and Field Properties

Chapter 4: Chapter 4 – Forms

Lecture 1: Course Review

Lecture 2: Auto-Create Forms, Filtering & Searching

Lecture 3: Types of Different Forms & Creating New

Lecture 4: Improve Look, Style, & Feel of Forms

Lecture 5: Adding Fields to Existing Form

Chapter 5: Chapter 5 – Expression Builder

Lecture 1: Understanding and Setting Up the Expression Builder

Chapter 6: Chapter 6 – Conditional Formatting

Lecture 1: Format Control on Forms/Reports

Chapter 7: Chapter 7 – Sorting and Filtering

Lecture 1: Sorting Single & Multiple Columns; Filter One Field Data Records

Lecture 2: Sorting & Filtering Data in Form View; Find & Replace in Forms

Chapter 8: Chapter 8 – Reports

Lecture 1: Understanding Reports & Structure

Lecture 2: Creating Reports; Using Print Preview to Check Report Outcome

Lecture 3: Advanced Reporting; Formatting Reports

Lecture 4: How to Improve Report Design, Add Existing Fields; Group/Sort

Chapter 9: Chapter 9 – Queries

Lecture 1: Select Queries; Sorting; Defined Criteria

Lecture 2: Change Fields wthin Query; Specifying Criteria for Numbers/Text

Lecture 3: Update Queries; Append Queries; Delete Queries

Lecture 4: Inner/Outer Joins; Make Table Queries; Mail Merge

Chapter 10: Chapter 10 – Security

Lecture 1: Securing Database and Views; New Features

Chapter 11: Quiz

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 0 votes
2 stars: 5 votes
3 stars: 12 votes
4 stars: 28 votes
5 stars: 49 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu