Microsoft Access 2010

1 Enrolled No ratings yet All Levels

Microsoft Access 2010 training course. In this Microsoft Access 2010 tutorial, you’ll learn how to enter, manage, and search through large amounts of data in an Access database.

Things you’ll learn in this course

1) Access Basics

  • Introduction to Databases
  • Introduction to Objects
  • Getting Started in Access
  • Managing Databases and Objects

2) Working With Data

  • Working with Tables
  • Working with Forms
  • Sorting and Filtering Records

3) Running Queries and Reports

  • Designing a Query
  • More Query Design Options
  • Creating Reports
  • Advanced Report Options

4) Database Design tips

  • Modifying Tables
  • Creating Forms
  • Formatting Forms
  • Designing Your Own Database

5) Database Normalisation

  • 1NF (First Normal Form)
  • 2NF (Second Normal Form)
  • 3NF (Third Normal Form)
  • BCNF (Boyce-Codd Normal Form)
  • 4NF (Fourth Normal Form)
  • 5NF (Fifth Normal Form)
  • 6NF (Sixth Normal Form)

6) Extras

  • How to Create Calculated Fields and Totals Rows
  • How to Create a Parameter Query
  • How to Create a Find Duplicates Query
  • Query Criteria Quick Reference Guide
  • Free Alternatives to Microsoft Office

7) Quiz

  • Test your knowledge of MS Access by taking our quiz

 

DISCLAIMER: Namepress is NOT a web design or a web hosting agency.

X