Course Highlights
- Use pre-built tables to start tracking your information immediately.
- Create select and action queries to seamlessly view and change your
data.
- Create multiple reports and save audience-specific views.
- Take advantage of the new Ribbon and interactive Access interface
to quickly build a database.
About This Course
This Microsoft Office Access 2007 Essentials Course will lead you through
the improved interface and interactive design capabilities of Access 2007.
With quick tips and detailed instructions, you will learn how to track
and report information with ease.
Access 2007 comes loaded with pre-built elements such as tables and field
names. In this course, you will learn how to take advantage of those elements
as well as how to import data from external applications, share your database
information, and much more.
This Microsoft Office Access 2007 Essentials Training Course contains
four levels of instruction designed to walk you through the database design
process and how to use Access to develop detailed databases. You will
learn how to work in-depth with many of the Access objects including Tables,
Forms, Queries and Reports.
There are over 100 lessons in this Access course – all designed
to increase your productivity.
Microsoft Access 2007: Beginner
1.0 Getting Started
1.1 About Relational Databases and Access 2007
1.2 Launching Access 2007
1.3 Touring the Access Environment
1.4 Using the Office Menu
1.5 Database Components
1.6 Using the Navigation Pane
1.7 Getting Help
1.8 Opening & Closing Access Databases
1.9 Creating an Access Database Using a Preloaded Template
2.0 Working with an Existing Table
2.1 Exploring Datasheet View
2.2 Editing & Selecting Table Data
2.3 Adding & Deleting Records
2.4 Find & Replace
2.5 Undo & Redo
3.0 Working with an Existing Form
3.1 Exploring Form View
3.2 Editing & Selecting Form Data
3.3 Adding & Deleting Records
3.4 Find & Replace
4.0 Sorting & Filtering
4.1 Sorting a Table and a Form
4.2 About Filters
4.3 Common Filters
4.4 Filter by Selection
4.5 Filter by Form
4.6 Advanced Filter
5.0 Designing Select Queries
5.1 Using the Query Wizard
5.2 Using Query Design View
5.3 Using Criteria
5.4 Sorting and Showing Query Fields
5.5 Adding Tables to a Query
6.0 Form Basics
6.1 Using the Forms Wizard
6.2 Using the Form Tool
6.3 Working with Form Design View
6.4 Working with Form Layout View
6.5 Working with Form Controls
7.0 Report Basics
7.1 Using the Reports Wizard
7.2 Using the Report Tool
7.3 Working with Report Design View
7.4 Working with Report Layout View
7.5 Working with Report Controls
8.0 Printing Database Objects
8.1 Printing Tables or Queries
8.2 Printing Forms
8.3 Printing Reports
Microsoft Access 2007: Intermediate
1.0 Planning & Designing a Database
1.1 Database Design Process
1.2 Creating a Database Using a Wizard
1.3 Creating a Database from Scratch
2.0 Building & Modifying Tables
2.1 Creating a Table Using a Table Template
2.2 About Data Types
2.3 Creating a Table in Datasheet View
2.4 Creating a Table in Design View
2.5 Using Field Templates
2.6 Setting Primary Keys
3.0 Working with Relationships
3.1 Types of Relationships
3.2 Referential Integrity
3.3 Cascading Updates and Deletes
3.4 Multi-Valued Fields
3.5 Printing Relationships
4.0 Sharing Your Data
4.1 Export Your Access Report to Word
4.2 Export Your Access Table to Excel
4.3 Import Your Excel Spreadsheet into Access
4.4 Copying the Table Structure and Data
5.0 Enhancing Your Forms
5.1 Using the Field List Task Pane
5.2 Using the Forms Controls Group
5.3 Adding & Formatting Labels
5.4 Adding Graphics
5.5 Adding Command Buttons
6.0 Enhancing Your Reports
6.1 Using the Reports Control Group
6.2 Adding Graphic Details
6.3 Working with White Space and Report Width
Microsoft Access 2007: Advanced
1.0 Preventing Data Entry Errors
1.1 Using the Lookup Wizard
1.2 Data Validation
1.3 Working with Combo Boxes
1.4 Working with List Boxes
2.0 Advanced Table Design
2.1 Field Properties
2.2 Using Input Masks
2.3 Using the Datasheet Total Row
2.4 Using Rich Text in the Memo Field
3.0 Advanced Query Design
3.1 Creating a Calculated Field
3.2 Creating a Crosstab Query
4.0 Advanced Form Design
4.1 Split Forms
4.2 Working with the Property Sheet
4.3 Changing Control Tab Order
4.4 Conditional Formatting
4.5 Adding Tab Pages
5.0 Advanced Report Design
5.1 Creating Groups and Total Reports
5.2 Working with Total Fields
5.3 Adding Calculated Controls to a Report
6.0 Managing Databases
6.1 Identify Object Dependencies
6.2 Database Documenter
Microsoft Access 2007: Expert
1.0 Expertly Designed Select Queries
1.1 Single Parameter Queries
1.2 Multiple Parameter Queries
1.3 Query Joins
2.0 Action Queries
2.1 Types of Action Queries
2.2 Update Queries
2.3 Append Queries
2.4 Make Take Queries
2.5 Delete Queries
3.0 Expertly Designed Forms
3.1 Creating a Lookup Field
3.2 Using a Bitmap as a Form Background
3.3 Adding Calculated Controls to a Form
4.0 Expertly Designed Reports
4.1 Setting Section Properties
4.2 Adding Graphics
4.3 Arranging Report Data Into Columns
5.0 Macros
5.1 Create a Macro
5.2 Edit a Macro
5.3 Attach a Macro to a Command Button
6.0 Database Security
6.1 About Database Security
6.2 Using a Database Password
| 
