Courses
Courses Designed For Beginners, Seasoned IT Pros & Everyone In Between
Access 2010
View All CoursesIf you are using a database that someone has already built and wish to modify or build your own queries, reports, PivotTables, PivotCharts, and calculated expressions, this course is a good starting point. This course is designed with novice Access users in mind, but serves as a quick reference for more experienced Access users.
Lessons
-
Lesson Clips
- Introduction
- Introduction to the Course
- About the Instructor
- Tour of the Course
- What We Covered
-
Lesson Clips
- Introduction
- Access 2010 Database Specifications
- Minimum Requirements for Access 2010
- Exercise Files
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Databases
- Flat-File Databases
- Relational Databases
- Introduction to Normalization
- Normalization Example
- Denormalization
- Designing Database Guidelines
- Trivia Time
- What We Covered
-
Lesson Clips
- Introduction
- Database Objects Overview
- Queries
- Forms
- Reports
- Macros
- Modules
- Key Terms You Should Know
- What We Covered
-
Lesson Clips
- Introduction
- Starting Microsoft Access 2010
- Creating a New File
- Creating a New Table
- Saving a Database
- Opening a Database
- Trusting a File
- The Quick Access Toolbar
- Backstage View
- Access Options Overview
- The Ribbon
- Contextual Tabs
- The Navigation Pane
- What We Covered
-
Lesson Clips
- Introduction
- Table Views
- Query Views
- Form Views
- Report Views
- Key Terms You Should Know
- What We Covered
-
Lesson Clips
- Introduction
- Navigating a Table or Query
- Keyboard Shortcuts
- Navigating a Form
- Navigating a Report
- What We Covered
-
Lesson Clips
- Introduction
- Creating a Single Item Form
- Automatic Subdatasheet Creation
- Creating a Multiple Items Form
- Creating a Split Form
- The Form Wizard
- Creating a Navigation Form
- Key Terms You Should Know
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Controls
- Resizing Controls
- Moving Controls
- Working with Layouts
- Adjusting the Tab Order
- Applying Themes
- What We Covered
-
Lesson Clips
- Introduction
- Kinds Of Queries
- Creating a Select Query Using the Simple Query Wizard
- Creating a Select Query from Design View
- Working with Fields
- Sorting and Filtering Records
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Criteria
- Introduction to Operators
- Adding Criteria to a Query
- Combining Criteria
- Adding Alternate Criteria
- Locating Blank Values (Nulls)
- Introduction to Wildcards
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Parameter Queries
- Creating a Parameter Query
- Changing the Parameter Prompt Order
- Using Wildcards and Functions with Parameter Queries
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Joins
- Types of Joins
- Creating an Inner Join
- Creating an Outer Join
- Creating a Self-Join
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Expressions
- Creating a Calculated Detail Field
- Building Expressions Using the Expression Builder
- Building Expressions in Forms and Reports
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Aggregate Queries
- Calculating a Group of Query Records
- Calculating a Group of Query Records From Datasheet View
- Calculating a Group of Query Records From Design View
- Grouping with Criteria and Calculated Fields
- Pitfalls of Summarizing Data
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Functions
- Basic Date/Time Functions
- The Month Function
- The Year Function
- Text Functions
- The LCase and UCase Functions
- The Left and Right Functions
- The Trim Function
- The Format Function
- Conversion & Math Functions
- The FormatCurrency Function
- The CCur Function
- The Round Function
- What We Covered
-
Lesson Clips
- Introduction
- Advanced Date/Time Functions
- The DatePart Function
- The DateAdd Function
- The DateDiff Function
- The Sum Function
- The Max & Min Functions
- The DMax & DMin Functions
- The DLookup Function
- Handling Null Values & Program Flow
- The Nz Function
- The IIf Function
- The Switch Function
- Using Functions in Macros
- Nesting Functions
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to PivotTables
- Creating a PivotTable
- Creating a Calculated Field
- Manipulating a PivotTable
- Exporting Data to Microsoft Excel
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to PivotCharts
- Creating a PivotChart
- Manipulating a PivotChart
- Changing Chart Types
- What We Covered
-
Lesson Clips
- Introduction
- Creating a Report Using the Report Tool
- Creating a Report Using the Report Wizard
- Creating a Report from Design View
- Creating Mailing Labels
- What We Covered
-
Lesson Clips
- Introduction
- Formatting Basics
- Controls
- Control Layouts
- Sections and Grouping
- Adding Controls & Page Elements
- Labels
- Text Boxes
- Pictures
- Page Numbers
- Date/Time
- Borders & Rectangles
- What We Covered
-
Lesson Clips
- Introduction
- Advanced Format Properties
- Filtering Reports
- Conditional Formatting
- Creating Data Bars
- Adding a Chart
- What We Covered
-
Lesson Clips
- Introduction
- Previewing a Report
- Printing a Report
- Exporting a Report
- What We Covered
-
Lesson Clips
- Introduction
Instructor
Heather Ackmann
Heather Ackmann is an accomplished instructor with a decade of teaching experience, helping students at the high school, college, and adult levels in a variety of topics. Specializing in Microsoft Office computer applications, she is a Microsoft Office Certified Master and holds a degree in English and Secondary Education.
While her energetic and easy-to-follow style is ideal for beginners to computer applications, her knowledge, thoroughness, and foresight will satisfy the more proficient user.
In her spare time, she enjoys blogging about her congenital anosmia at www.neversmell.com.
