Microsoft Access 2007
Course Outline
- Over 17 Hours of Instructor Led Video Training so you can Master Database Design using Access 2007
- Total Beginner to Intermediate Training on Access 2007's New Interface and Improved Features
- Create Tables, Forms, Queries and Impressive Reports with Expert Instruction
- 70-602 MCAS: Using Microsoft Access 2007 Certification Exam Coverage
Here are some of the training topics you will find in our Microsoft Access 2007 Training Videos:Introduction to Access 2007 Course
- Instructor's Introduction
- Course Introduction
- Exam Objectives for Exam 77-605 Using Microsoft Office Access 2007
- Introduction to Relational Databases
- Relational vs. flat-file
- Important thing to remember when working with Access: Access is NOT Excel!
- The General Order for Building Databases
- The Scenario for the course - Building a database for Picaroon Publishing Unlimited, a small literary press, to keep track of employees, customers, orders, authors, and more.
Welcome to Microsoft Access 2007
- Getting acquainted with Getting Started Screen
- Using Microsoft Access Database Templates
- Creating a New Blank Database in Access
- Opening an existing Access Database
- The Message Bar in Access 2007
- “Certain content in the database has been disabled”
- How to enable executable content
- Basic Commands Behind the Microsoft Office Button
- Toolbars! I don't Need No Stinking Toolbars! (New Access 2007 Ribbon )
- Using the Quick Access Toolbar
- Using a Dialog Box Launcher
- Navigation Pane - Where the Heck is my Database Window?
Intro to Microsoft Access Objects
- Types of Objects and What they look like in Access:
- Tables
- Queries
- Forms
- Reports
- Getting Familiar with Basic Views in Access
- The Datasheet View
- The Design View
- The Layout View
- The Print Preview
Designing a Database in Access 2007
- A Brief Recap of Our Scenario
- A small press, Picaroon Publishing Unlimited, wants to build an Access database to keep better track of their products, customers, and employees
- How to plan a database
- How to Normalize your database
- How to plan for Relationships
- The Need for Keys
- Why a primary key is necessary
- Why a foreign key is necessary
Building Tables
- Scenario: Build Tables to store company data for Picaroon Publishing Unlimited
- Building a Table from Datasheet View
- An Brief Introduction to Naming Conventions
- Overview of different Data Types
- How to Add Records
- How to Navigate in a Datasheet using both the mouse and Keyboard Shortcuts
- How to Build a Table in Design View
- Overview of different Data Types
- How to add Descriptions
- Using Advanced Properties
- How to Navigate in Table Design View (using both the mouse and Keyboard Shortcuts)
- Using the Microsoft Table Templates
Advantages and Disadvantages of Templates
Modifying Tables in Microsoft Access 2007
- How to Control Data Entry
- Creating Input Masks
- Using Validation to restrict data entry
- Creating Lookup Fields
- Using the Access Find and Replace Dialog Box
- Sorting Data in Access
- Filtering Data in Access
Creating Basic Relationships
- Creating a One-To-One Relationship
- Creating a One-To-Many Relationship
- Enforcing Referential Integrity
- Turning on the Cascade Update Feature
- Turning on the Cascade Delete Feature
- Creating a Subdatasheet
- Entering Information
- Viewing information
Advanced Relationships in Access 2007
- Building a many-to-many relationship
- Creating Multiple Keys
- Building a Pass-through relationship
Query Basics
- The purpose of queries
- Types of queries
- Creating a Select Query
- using the Query Wizard
- in Design View
Finding Specific Data
- Introduction to Criteria
- An Introduction to using Operators
- Mathematical
- Relational/Comparison
- Logical
- String
- Other
- Using Wildcards
What are Flexible (parameter) Queries?
- Benefits of using a flexible query
- Creating a flexible query
- Using Wildcards with a flexible query
How to Create Calculations in a Query
- Introduction to Calculations
- Creating a Calculated Detail Field
- Calculating a Group of Records
- Introduction to Built-in Functions
- The DateDiff Function
- Format Functions
What are Joins?
- Introduction to Query Joins
- Creating an Inner Join
- Creating an Outer Join
- Creating a Self Join
What are Action Queries?
- Creating an Append Query
- Creating a Delete Query
- Creating a Make-Table Query
- Creating an Update Query
Using Special Query Wizards
- The Crosstab Query Wizard
- The Find Unmatched Query Wizard
- The Find Duplicates Query Wizard
Introduction to PivotTables and PivotCharts
- Creating a PivotTable
- Modifying a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Modifying a PivotChart
- Formatting a PivotChart
Creating Basic Forms in Access 2007
- An overview of Form Views
- Creating Forms
- Using the wizard
- In design view
- Modifying Forms
- In layout view
- In design view
- Adding Special Tools
- Adding Images to forms
- Creating an Option Group Control
- Creating a Calendar Control
- Creating Command Buttons
Introduction to Security Settings
- The Trust Center
- Enabled vs. Blocked Executable Content
- Creating Trusted Locations
Designing Macros in Access 2007
- Creating a Macro
- Adding a macro to form control
- Embedded Macros
- Controlling Data through Macro Conditions
- Building a macro to run automatically
The Switchboard Manager
- Creating a Switchboard
- Editing a Switchboard
Printing Records Using Reports
- Creating Reports
- Formatting Reports
- Adding Calculated Fields
- Sorting and Grouping Data
- Exploring Printing Options
- Adding a Chart to a Report
Importing and Exporting Data within Microsoft Office
- Importing an Access Object
- Import a Microsoft Excel Spreadsheet
- Import a Text File
- Export a Table to Microsoft Word
- Export a Query to Microsoft Excel
- Export a Report to Microsoft Excel
- Create a Mail Merge with Microsoft Word
Getting Help When You Need It
- Microsoft Access Help
- Microsoft Communities
- Other Online Forums
