Intermediate
Microsoft Access 2010

Course Content

• Lesson 1: Controlling Data Entry
  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field
• Lesson 2: Joining Tables
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table
• Lesson 3: Creating Flexible Queries
  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
• Lesson 4: Improving Forms
  • Restrict Data Entry in Forms
  • Organize Information with Tab Pages
  • Add a Command Button to a Form
  • Create a Subform
  • Display a Summary of Data in a Form
  • Change the Display of Data Conditionally
• Lesson 5: Customizing Reports
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
• Lesson 6: Sharing Data Across Applications
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

---

All Access Courses

Access 2010 Classes	Access 2007 Classes	Access 2003 Classes
What's New in Access 2010 > Introduction > Intermediate > Advanced >	What's New in Access 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Access >

---