Detailed item view

The Fastest, Easiest Way to Learn Microsoft Access 2010!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Chapter 1: Office Workspace Basics
Approximate Time 80 minutes - 77 lessons - 7 Topics

• Basic Window Elements
• Exploring Office Backstage
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: Introduction to Access
Approximate Time 60 minutes - 60 Lessons - 7 Topics

• What is an Access Database
• Opening a Database File
• Exploring Database Objects
• Creating a Database
• Changing Views
• Printing Database Objects
• Saving and Closing a Database File

Chapter 3: Working with Tables
Approximate Time 70 minutes - 72 Lessons - 11 Topics

• What is a Table?
• Working with Datasheets
• Moving Among Records
• Updating Records
• Adding Records to a Table
• Selecting Rows and Columns
• Finding Records
• Sorting Records
• Filtering Records
• Using the PivotChart View
• Saving and Closing a Table

Chapter 4: Designing Tables
Approximate Time 70 minutes - 69 Lessons - 9 Topics

• Adding a Table to a Database
• Adding Fields to a Table
• Adding a Lookup Field
• Setting a Primary Key
• Using the Input Mask Wizard
• Saving Design Changes
• Importing Data
• Exporting Data
• Performing Database Maintenance

Chapter 5: Creating and Running Queries
Approximate Time 70 minutes - 74 Lessons - 10 Topics

• What is a Query?
• Creating a Query
• Working with Queries
• Saving and Running a Query
• Creating Calculated Fields
• Using Agregated Functions
• Understanding Query Properties
• Creating Multi-Tables Select Queries
• Joining Tables
• Enforcing Referential Integrity

Chapter 6: Using Forms
Approximate Time 60 minutes - 57 Lessons - 7 Topics

• What is a Form?
• Using the Form Tool
• Creating a Form with the Form Wizard
• Working in Design View
• Changing the Form Layout
• Using Calculated Controls
• Working with Records on a Form

Chapter 7: Generating Reports
Approximate Time 70 minutes - 74 Lessons - 10 Topics

• What is a Report?
• What is a Report Tool?
• Previewing and Printing a Report
• Saving a Report
• Designing a Report
• Changing a Report Layout
• Understanding Controls
• Using a Calculated Control
• Analyzing Dependencies
• Creating Mailing Labels

OPERATING SYSTEM Windows™ 7/Vista/XP/2000

SYSTEM REQUIREMENTS Pentium™ PC or Higher 150 MB Hard Disk Space per application Sound Card CD-ROM Drive 1024 x 768 16 Bit colour display or higher Speakers or Headphones