MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

The Ultimate Microsoft Access 2010 Training Course

Course Summary

Have all the database terms, data, and reports got you down? Demystify Access forever with this effective course.


  • +

    Course Syllabus

    • Getting to Know the Workspace
      • Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
      • Start/Exit, Help Features, Shortcuts, Views, Templates
    • Access Basics
      • Understanding Database Components15
      • Introduction to Design of a Database
      • Introduction to Building a Database
    • Tables
      • Creating Tables & Basic Setup of Relationships
      • Using Quick Parts to Setup New Table, Importing Spreadsheet
      • Entering Data Types into Tables
      • Changing Table Attributes, Copy, Rename, Delete Records
      • Table Structures
      • Table and Field Properties
    • Forms
      • Auto-Create Forms, Filtering & Searching
      • Types of Different Forms & Creating New
      • Improve Look, Style, & Feel of Forms
      • Adding Fields to Existing Form
    • Expression Builder
      • Understanding and Setting Up the Expression Builder
    • Conditional Formatting
      • 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
      • Course Review
      • Understanding Reports & Structure
      • Creating Reports; Using Print Preview to Check Report Outcome
      • Advanced Reporting; Formatting Reports
      • How to Improve Report Design, Add Existing Fields; Group/Sort
    • Queries
      • Select Queries; Sorting; Defined Criteria
      • Change Fields wthin Query; Specifying Criteria for Numbers/Text
      • Update Queries; Append Queries; Delete Queries
      • Inner/Outer Joins; Make Table Queries; Mail Merge
    • Security
      • Securing Database and Views; New Features
    • Access 2010 Quiz
      • Assessment Test
    • Introduction to Advanced Access 2010
      • Introduction
    • Macros
      • Working with Macros
      • AutoExec Macro
    • Database Options Before Distribution
      • Database Options
      • More Database Options
    • Naming
      • Renaming Database Objects
    • Tables Review of Table
      • Basics & Understanding Data Types
      • Table Field Properties
      • Validation Rules & Tex
    • Keys and Indexes
      • Understanding & Using Keys and Indexes
    • Normalization
      • Data Normalization
    • Relationships
      • Types of Relationships
      • Maintaining Relationships
    • Queries
      • Using & Understanding Queries
      • Complex Queries
      • Creating Queries and Using Join & Sub-Queries
    • Datasheet View
      • Datasheet View
    • Forms
      • Creating & Working with Forms
      • Using Forms to Maintain Data
      • Command Buttons
      • Command Buttons Part 2
      • Visual Basic for Applications
    • Visual Basic for Applications
      • Understanding When & How to Use VBA
      • More about VBA and Using It to Improve Database
      • VBA Language Structure & Making a Switchboard
      • Error Handling
    • Polishing Up
      • Cleaning Up Before Distribution16
    • Security
      • Security Techniques
    • Import/Export
      • External Data & Importng/Exporting Data
    • Linking to Data
      • Linking to Excel & Linking to Another Database
    • Splitting Database
      • Separating/Splitting Up Forms, Reports, etc from Database
    • Multi-User
      • Options for Making Changes When Database is Multi-User
    • Reports
      • Advanced Features for Reports
      • Advanced Features for Reports part 2
    • Package & Distribute
      • Distributing Application
    • Access 2010 Advanced Quiz
      • Assessment Test


Course Fee:
USD 177

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top