Module Title : Course 50532A: Learn Microsoft Office Access 2010 Step by Step, Level 1

Duration : 1 day

Part 1 Simple Database Techniques

Explore an Access 2010 Database

  • Working in Access 2010
  • Sidebar: Enabling Macros and Other Database Content
  • Understanding Database Concepts
  • Exploring Tables
  • Sidebar: Tabbed Pages vs. Overlapping Windows
  • Exploring Forms
  • Exploring Queries
  • Exploring Reports
  • Previewing and Printing Access Objects
  • Key Points

Create Databases and Simple Tables

  • Creating Databases from Templates
  • Sidebar: Web Databases
  • Creating Databases and Tables Manually
  • Sidebar: Database Design
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables
  • Key Points

Create Simple Forms

  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms
  • Key Points

Display Data

  • Sorting Information in Tables
  • Sidebar: How Access Sorts
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Sidebar: Wildcards
  • Locating Information That Matches Multiple Criteria
  • Sidebar: Saving Filters as Queries
  • Key Points

Create Simple Reports

  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports
  • Key Points