Microsoft Access 2010: Beginner to Advanced

Curriculum

Introduction
„ Instructor Introduction
„ Access Overview
„ Course Outline

Section 1: Access Basics
„ Section Overview
„ What Does Access Do?
„ Access Application Window
„ Database Objects
„ Basic Database and Table Management
„ Customizing Access
„ Keyboard Shortcuts
„ Section Review

Section 2: Designing a Database
„ Section Overview
„ Database Design Process
„ Normalizing Data
„ Setting Primary and Foreign Keys
„ Section Review

Section 3: Building a Database
„ Section Overview
„ Creating A New Database
„ Creating Tables
„ Inserting Field’s in Tables
„ Setting Up Field Properties
„ Formatting the Datasheet View
„ Creating Relationships
„ Keyboard Shortcuts
„ Section Review

Section 4: Managing Table Data
„ Section Overview
„ Updating and Deleting Records
„ Finding and Replacing Values
„ Adding a Total Row
„ Using Sub-datasheets
„ Sorting Data
„ Filtering Data
„ Keyboard Shortcuts
„ Section Review

Section 5: Creating Selection Queries
„ Section Overview
„ Creating Queries Using the Query Wizard
„ Creating Queries Using the Query Design View
„ Adding Criteria
„ Add Calculated Fields to Query
„ Section Review

Section 6: Creating and Managing Forms
„ Section Overview
„ Form Basics and Creating Forms
„ Contextual Tabs Design and Layout View
„ Managing Table Data with Forms
„ Modifying the Look and Design
„ Design Tab Controls
„ Section Review

Section 7: Creating and Managing Reports
„ Section Overview
„ Creating Reports, Report Views, and Managing Report Sections
„ Adding Calculated Fields and Formatting The Report Controls
„ Section Review

Section 8: Controlling Data Entry
„ Section Overview
„ Setting Field Properties
„ Validation Rules
„ Input Mask
„ Create Lookup Field
„ Section Review

Section 9: Finding and Joining Data
„ Section Overview
„ Inner and Outer Joins
„ Joining Unrelated Tables and Relating Data Within Tables
„ Section Review

Section 10: Creating Flexible Queries
„ Section Overview
„ Select Query Properties
„ Parameter Queries
„ Using Wild Cards
„ Creating Action Queries
„ Section Review