 Access
2007 Training Course
Microsoft Access 2007 Training Video Course
Access 2007 Training Demo
In this video, we show you how to Create
Flexible Queries: Using Parameters.
With parameter queries, you can design one query that will output or retrieve
multiple data results based around user input. With parameter queries, you can
save your end-users time and give them the choice of what data they want to see
when.
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
The Complete Train Signal FastTrack Video
CBT Training Library
Buy "Access 2007" as Part of our
Complete FastTrack Video CBT Training Library...
Every Course we Have on a USB Hard Drive
Check it Out Now!
Access 2007
Only £90 (ex vat &
del)
Multi user pricing available - call sales now
Official Purchase orders accepted from
Government, Education, Health & Charity, Times 1000 plc's, Professional
Partnerships
and other pre-approved accounts. Want to order more than one course ? Contact sales for a custom quote.
| 