- Access 2007 Course

Whether an advanced or first time database user, Access 2007 delivers powerful tools for managing and analyzing data. Learn efficient database design, how to create effective tables and the secrets of querying. Know the logistics of data types and Auto-number fields. Also, see how to create and edit reports, charts and easy-to-use Switchboard forms. No marketing department should try to manage mass-mailings without the help of this great program.

After watching this amazing course you will also know how to add Forms, Databases and Charts to make any presentation very compelling.

Learn at your own pace
Build exactly the skills you need
Master the tools for building a database that makes information easier to find and use
Link to data from other Microsoft Office applications, HTML and XML files, and other databases
Use forms, filters, queries, and reports to capture and analyze data
Learn ways to prevent data corruption and unauthorized access
Share your data with colleagues and customers through interactive Web pages
Prepare for the Microsoft Office User Specialist (MOS) exam

Microsoft Office Specialist

Join... It's FREE! CD-ROM Version

This is a 6 hours course.
You will learn virtually everything you need to know about Access 2007.

Lessons:
Understanding Databases Welcome What is a database? Introduction to the Interface The different Views Create a Table in Design View Primary Keys Utilizing the Wizard Datasheet View	Controlling the Database Editing Datasheet View Row Height Adjustment Adjusting with Column Width Working with Columns How to Freeze Columns Formatting Text Sorting Text	Sorting Information Finding Information and Replacing Information Filtering Filtering by Form Filtering with some features Relationships
Database Relations Integrity Adding more Tables to your relations Simple Query Wizard	Query Data Query in Design View Query multiple tables in Design View Presorting a Query Choosing the Criteria Hiding a Column of Data	Access Forms Introduction to Forms Adding a Record into a Form Automatic Form Creation
What are Reports? Create Reports with Wizard Automatic Reports	Controlling Columns and More Create a New Column Sub Data Sheet Look Up Hyperlink Relationships Character Length/Field Size	Data Types,Query Control Number Fields Date/Time Data Types Yes/No Data Types Default Values for Access Rules for Validation Locate Date info with < = And Or Condition Using the Between Statement Wild Card Creating a Calculated field Grouping By Parameter Query & Compound Parameter Query Make A Table from a Query Update Query Delete Query Cross Tab Query Wizard Using a text file for creating a Database using Notepad Importing the text file and Delimiting.
Advanced Control with Forms Welcome to Disk 2 Password Protecting the Database Compacting a Database/Unset Password Creating a form using wizard and the controls Working with Controls and Deleting Align Controls Working with Field List Spacing Tool box Label Properties for objects Importing an Image Editing a control Creating a form with the wizard & understanding sections Combo Box List box Rectangle with Drop Shadow Tab Order Header and Footer Autoforms Check Box and Option Box All Properties	Utilizing Reports Creating a basic report Grouping Data Inserting a Date Insert a Page Break Margin Control Mailing Labels Font Control Format Painter SpellCheck Switchboard	Expression Builder Expression Builder Calculation
Web Export Understanding the Types of Web Pages Exporting A Database Into HTML Creating a Data Access Page Auto Page Columnar	Macros A Basic Macros Open Report Open Query for Edit	Putting it all together! Creating a Basic Database from Scratch Customizing the form Datasheet View Jumping to different Fields Printing a Report from our Work Query Data for your Database Inserting a Graphic Photos for Each Record Creating a Macro User and Group Permissions Switch Board Control