Microsoft Access 2007: Introduction and Intermediate

Course Overview

Our Microsoft Access Introduction Training Course you will explore database basics and build tables and reports that corral your data

Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, this MS Access Introduction Training Course is where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other Office applications, use wizards to automate your work, and much more.

Discover how to

• Create a new Access database
• Import and export data
• Build forms for efficient data entry
• Search tables for specific data
• Construct custom reports
• Customize your database navigation

Not sure whether this is the right Microsoft training course for you? Use our quick search bar to find the right Microsoft training course for you.

Related Courses

• Microsoft Access 2007: Introduction for Beginners (2 day)
• Microsoft Access 2007: Building Applications with microsoft Access
• Microsoft Access 2007: Introduction for Beginners (1 day)
• Microsoft Access 2007: Advanced (1 day)
• Microsoft Access 2007: Level 4 (1 day)
• Microsoft Access 2007: Intermediate (1 day)
• Microsoft Access 2007: Advanced
• Microsoft Access 2007: Introduction for Beginners
• Microsoft Access 2007: Intermediate
• Microsoft Access 2007: Visual Basic for Applications (VBA)

Audience

This course requires no experience of creating databases or of using Microsoft Access.

Course Outline

Fundamentals

• Basic database concepts
• Designing a basic database
• Overview of MS Access
• Opening an existing database
• The Access environment
• Access Objects
• Editing an Access table
• Navigating through a table
• Deleting records
• Adding new records
• Finding and sorting

Creating tables

• Creating an Access database
• Creating tables in design view
• Using the Table Wizard
• Setting field attributes
• Setting a primary key
• Datasheet view

Filtering and sorting

• Finding records
• Filtering records
• Filtering with forms
• Sorting records

Working with forms

• Overview of forms
• Using the Form Wizard
• AutoForms
• Bound and unbound forms
• Data validation
• Adding records via a form

Relationships

• Relationships overview
• Creating relationships
• About referential integrity

Queries

• Design view queries
• Setting criteria
• Using the query wizard
• Sorting queries
• Modifying and updating queries
• Querying multiple tables

Creating reports

• AutoReports
• The Reports Wizard
• Formatting a report
• Linking reports to queries
• Generating groupings
• Creating custom headers
• Adding your logo
• Printing reports