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

Learn Microsoft Access 2010

Course Summary

ClipTraining is relied upon by the Fortune 100 to K12 schools everywhere! Learn how to use Access 2010 from the experts.


  • +

    Course Syllabus

    • Introduction and Auxiliary Materials
      • Introductory Lecture
    • Getting Started
      • Introduction to Databases
      • Getting Started
      • Understanding the Access Environment
      • Working with Backstage View
      • Using the Navigation Pane
      • Introduction to Tables
      • Introduction to Queries
      • Introduction to Forms
      • Introduction to Reports
      • Creating a Database Using a Template
      • Creating a Blank Database
      • What’s New in Access 2010
    • Working with Tables
      • Designing a Relational Database
      • Creating a Table in Datasheet View
      • Creating a Table in Table Design
      • Designating Primary Keys
      • Adding Records to a Table
      • Modifying the Table Structure
      • Modifying Field Properties
      • Modifying Table Layouts
      • Finding and Replacing Data in Tables
      • Sorting Data in Tables
      • Filtering Tables
      • Creating a Lookup Field
      • Creating Table Relationships
      • Working with Subdatasheets
    • Creating Queries
      • Creating a Query using the Simple Query Wizard
      • Creating a Query in Query Design
      • Adding, Deleting, and Rearranging Fields in a Query
      • Sorting Records in a Query
      • Specifying Criteria in a Query
      • Saving, Copying and Changing a Query
      • Showing Totals
      • Creating Calculated Fields
      • Performing Calculations on Grouped Records
      • Creating a Query from a Query
    • Creating Forms
      • Creating a Form
      • Creating a Form Using the Form Wizard
      • Creating a Form in Form Design
      • Using a Form to Add Records
      • Finding and Modifying Records Using a Form
      • Modifying a Form
      • Formatting a Form
    • Creating Reports
      • Creating a Report
      • Using the Report Wizard
      • Creating a Report in Report Design
      • Modifying a Report to Add and Arrange Controls
      • Adding a Calculated Control
      • Adding Grouping and Sorting in Reports
      • Adding Totals to a Report
      • Modifying a Report to Align Fields
      • Formatting Controls in a Report
      • Adding Conditional Formatting to a Control
      • Applying Themes to a Report
      • Previewing and Printing Reports
      • Creating Labels
    • Import and Export Data
      • Importing Excel Data
      • Linking Data
      • Exporting Data to Excel
      • Using Access Data with a Word Merge
    • More on Queries
      • Using the Find Duplicates Query Wizard
      • Using the Find Unmatched Query Wizard
      • Using the Crosstab Query Wizard
      • Designing a Make Table Query
      • Creating a Delete Query
      • Designing an Update Query
      • Creating an Append Query
      • Creating a Parameter Query
      • Creating a Top Values Query
      • Creating a PivotTable and PivotChart


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

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