|
Microsoft Access 2007 for Users
Need to use Microsoft Access 2007 databases? This class gives you everything you need.
Based on years of teaching and using Access, and listening to our learners, we have created this Access Users course, teaching the key topics that you need to maximize productivity.
Microsoft Access 2007 is a powerful database program you can use to store and organize all kinds of information from a simple list of recipes to a catalogue with tens of thousands of products. When you know how, Access makes your data easy to find, analyze, and report.
This one day course will get you started with relational databases, including working with tables, creating simple data entry forms, setting up simple queries, and creating and printing reports
Course Outline
Chapter One: The Fundamentals
Introduction to Databases
The Getting Started Page and Opening a Database
Understanding the Access Program Screen
Understanding the Ribbon
Using the Office Button and Quick Access Toolbar
Using Keyboard Commands
Using contextual Menus
Using Help
Chapter Two: Database Basics
Working with Database Objects
Tour of a Table
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Converting an Access Database
Exiting Access 2007
Chapter Three: Working with Tables
Adding, Editing and Deleting Records
Selecting Data
Cutting, Copying and Pasting Data
Using Undo and Redo
Adjusting and Rearranging Rows and Columns
Finding and Replacing Data
Sorting Records
Using Common Filters
Filtering by Selection
Filtering by Form
Checking Your Spelling
Understanding Relationship Types
Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Chapter Four: Creating and Using Queries
Creating a Query
Sorting a Query
Using AND and OR Operators in a Query
Chapter Five: Creating and Using Forms
Creating and Using a Form
Creating a Form with AutoForms
Creating a Form with the Form Wizard
Understanding Form Views
Change Form Views
Chapter Six: Creating Reports
Create a Report
Create a Report with the Report wizard
Student Practice Files for this class are located here.
|