UDEMY
UDEMY Logo

Microsoft Access 2010 Tutorial 

  • Offered byUDEMY

Microsoft Access 2010 Tutorial
 at 
UDEMY 
Overview

Gain a solid foundation and skills in using Microsoft Access 2010, a relational database management system

Duration

7 hours

Total fee

529

Mode of learning

Online

Difficulty level

Intermediate

Official Website

Go to Website External Link Icon

Credential

Certificate

Microsoft Access 2010 Tutorial
 at 
UDEMY 
Highlights

  • Certificate of completion
  • Access on mobile and TV
  • Full lifetime access
  • 30-Day Money-Back Guarantee
Read more
Details Icon

Microsoft Access 2010 Tutorial
 at 
UDEMY 
Course details

Who should do this course?
  • The course is intended for anyone new to database concepts and wishing to use Access 2010.
What are the course deliverables?
  • 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
More about 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. You learn to create a single table, understand field types and properties, create input forms and generate reports. Advanced features covered under this are 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. Course provided by Udemy

Microsoft Access 2010 Tutorial
 at 
UDEMY 
Curriculum

Getting to Know the Workspace

READ ME: Essential Information for a Successful Training Experience

Course transcripts

Access Basics

Understanding Database Concepts

Introduction to Building a Database

Tables

Using Quick Parts to Setup New Table, Importing Spreadsheet

Entering Data Types into Tables

Forms

Course Review

Auto-Create Forms, Filtering & Searching

Expression Builder

Understanding and Setting Up the Expression Builder

Conditional Formating

Format Control on Forms/Reports

Sorting and Filtering

Sorting Single & Multiple Columns; Filter One Field Data Records

Sorting & Filtering Data in Form View; Find & Replace in Forms

Reports

Creating Reports; Using Print Preview to Check Report Outcome

Advanced Reporting; Formatting Reports

Queries

Select Queries; Sorting; Defined Criteria

Change Fields wthin Query; Specifying Criteria for Numbers/Text

Security

Securing Database and Views; New Features

Quiz

Assessment Test

Other courses offered by UDEMY

649
– / –
11 hoursCertificate
– / –
– / –
3.2 K
– / –
3.5 K
– / –
View Other 2339 CoursesRight Arrow Icon
qna

Microsoft Access 2010 Tutorial
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...