Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 

Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!

PlanComparison

Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!


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

 



Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
Visio
2003 / 2007
OneNote
2003 / 2007
Project
2003 | 2007
Sharepoint
3.0
Access
2010 | 2007
Excel
2010 | 2007
Outlook
2010 | 2007
PowerPoint
2010 | 2007
Word
2010 | 2007
Office for Mac
2008
Excel for Mac
2008
Entourage for Mac
2008
PowerPoint for Mac
2008
Word for Mac
2008

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003


Typing Speed Test
Test your typing speed with our certified typing speed test today.



  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2011 National Computer Science Academy, All Rights Reserved.