Microsoft Office 2007 Training

Microsoft Office 2007 Training

Learn Microsoft Office Access 2007 Step by Step, Level 2

Microsoft 50136

Microsoft Certification

Length: 1 Days
Published: February 02, 2009
Language(s): English
Audience(s): Information Workers
Level: 100
Technology: Microsoft Office Access 2007
Type: Course
Delivery Method: Instructor-led (classroom)
About this Course
This one-day instructor-led course provides students with an overview of the more complex features and functions of Microsoft Office Access 2007.
Audience Profile
This course is intended for information workers who want to learn intermediate-level Access 2007 skills.
At Course Completion
After completing this course, students will know how to control the types of data that can be entered in a table, extract or manipulate data by using queries, and customize forms and reports to meet their needs. They will also know how to customize and maintain an Access database and how to prepare a database that will be used by other people. Specifically, they will be able to:
  • Restrict the type and amount of data in a field.
  • Specify the format of data in a field.
  • Restrict data by using validation rules.
  • Create a simple or multi-column lookup list.
  • Add controls to a form.
  • Enter data in a form by using VBA.
  • Create a form by using an AutoForm.
  • Add a subform to a form.
  • Locate information that matches multiple criteria.
  • Create a query by using a wizard or manually.
  • Perform calculations by using a query.
  • Update information in a table.
  • Delete information from a table.
  • Create a report by using a wizard or manually.
  • Modify report design and content.
  • Add a subreport to a report.
  • Preview and print a report.
  • Make favorite Access commands quickly available.
  • Create custom categories.
  • Assign a password to a database.
  • Prevent database problems.
  • Create a switchboard.
  • Control the features available to database users.
  • Prevent changes to database code.
  • Secure a database for distribution.
Microsoft Training Discount Price Match Guarantee Microsoft Training Locations Redeem your Microsoft Training Vouchers here!