Courses
Courses Designed For Beginners, Seasoned IT Pros & Everyone In Between
Access 2007
View All CoursesIf you are tasked with building a new database, fixing your company’s Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report data more efficiently by walking you through the database design process, teaching you how to build tables and forms to enter data, and how to design queries and reports to retrieve and view data. No experience with Access or database design is necessary; however, experience with Microsoft Office applications and data entry is helpful.
Lessons
-
Lesson Clips
- Introduction
- Introduction to Your Instructor
- Course Introduction
- Overall Design
- The Scenario for the Course
- Exam Objectives
-
Lesson Clips
- Introduction
- Why IT Departments "Hate" Access
- Introduction to Relational Databases
- The General Order for Building Databases
-
Lesson Clips
- Introduction
- Getting Acquainted with the Getting Started Screen
- Using Microsoft Access Database Templates
- Creating a New Blank Database in Access
- Opening an Existing Access Database
- Enabling “Certain Content” Using the Message Bar
- The Microsoft Office Button
- The New 2007 MS Ribbon
- The Quick Access Toolbar
- Dialog Box Launchers
- The Navigation Pane
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Introductory Concepts
- Types of Basic Objects
- Tables
- Forms
- Queries
- Reports
- Datasheet View/Design View
- Form View/Report View
- Pivot Table/Pivot Chart View
- SQL View
- Layout View
- Print View
- Relationships View
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- How NOT to Design a Database
- How to Design a Database
- Keys and Relationships
- The Rules of Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Other Rules
- Steps for Designing a Database
- Our Scenario
- Our Plan
- Terminology
-
Lesson Clips
- Introduction
- Overview of Methods for Building Tables
- Building Picaroon's Main Employee Table (tblEmployees) from Datasheet View
- Introduction to Table Naming Conventions
- Overview of Different Data Types
- Adding Records
- Navigating in Datasheet View
- Building tblHRData in Design View
- Keyboard Shortcuts for Design View
- Looking at Table Templates
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Controlling Data Entry
- Using Formats
- Using Input Masks
- Using Data Validation
- Using Look-Up Fields
- Advanced Table Properties
- Indexing
- Unicode Compression, IME Mode/IME Sentence Mode
- Smart Tags
- Functioning Inside Tables
- Customizing Tables
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- What's the Plan Again?
- Build Our Customer and Orders Table
- Build Our Author and Products Table
- Build the Rest of Our Tables
- What We Covered
-
Lesson Clips
- Introduction
- Relationships Overview
- Creating a One-To-One Relationship
- Creating a One-To-Many Relationship
- Enforcing Referential Integrity
- Turning on Cascade Update and Cascade Delete
- Introduction to Subdatasheets
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Data Limits with Previous Relationships
- The Need for Other Relationships
- Many-To-Many
- Example 2 of Many-to-Many Relationship
- Pass-Through Relationship
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Overview of Queries
- The Purpose of Queries
- Types of Queries
- Uses for Queries
- Creating a Select Query
- Creating Queries Exercises
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Introduction to Criteria
- Introduction to Operators
- Mathematical Operators
- Relational/Comparison Operators
- Practice Using Criteria - Part 1
- Logical Operators
- Other Operators
- Practice Using Criteria - Part 2
- Wildcards
- What We Covered
-
Lesson Clips
- Introduction
- Benefits of Using a Flexible Query
- Creating a Flexible Query
- Using Operators and Wildcards inside Flexible Queries
- Query: Single/Multiple Dates and Date Range
- Query: Retail Price and Quantity Sold
- Query: Part of a Company Name
- What We Covered
-
Lesson Clips
- Introduction
- Introduction to Calculations
- Creating a Calculated Detail Field
- Calculating a Group of Records
- Aggregate Options
- Introduction to Built-in Functions
- The DateDiff Function
- Format Functions
- IIf Function
- Fun with Concatenation
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Introduction to Query Joins
- Creating an Inner Join
- Creating an Outer Join
- Creating a Self Join
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Review of Select Queries
- Introduction to Action Queries
- Creating an Append Query
- Creating a Delete Query
- Creating a Make-Table Query
- Creating an Update Query
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- The Crosstab Query Wizard
- The Find Duplicates Query Wizard
- The Find Unmatched Query Wizard
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Creating a PivotTable
- Adding Fields
- The PivotTable View
- Creating Calculated Detail Fields
- Adding Group Totals
- Modifying a PivotTable
- Expanding/Collapsing Fields
- Formatting Fields
- Adding a Splash of Color
- Creating a PivotChart
- The PivotChart View
- Changing Chart Options
- Adding/Removing Fields
- Formatting the PivotChart
- What We Covered
-
Lesson Clips
- Introduction
- Form/Report View
- Ways to Create Forms
- Tour of Create Tab Form Options
- Using the Form Wizard
- Creating a Form from Design View
- Parts of a Form
- How to Modify/Edit Forms
- Adding Form Controls - Adding Images
- Creating a Calendar Control
- Creating an Option Group Control
- Creating a Subform
- Creating Command Buttons
- Setting Form Properties
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Introduction to Macros
- Introduction to Security
- Creating a Basic Macro
- Embedded Macros
- Advanced Macro Techniques
- Creating Conditions
- Building a Macro to Run Automatically
- What We Covered
- Terminology
-
Lesson Clips
- Introduction
- Ways to Create Reports
- Using the Report Wizard
- How to Modify/Edit Reports
- Creating a Report from Design View
- Grouping and Sorting
- Adding a Company Logo
- Adding Reports Controls
- Other Report Properties
- What We Covered
-
Lesson Clips
- Introduction
- Protecting Data
- Overview of Switchboards
- Creating a Switchboard
- Using the Switchboard Manager
- Your Main (Default) Switchboard
- Customizing Startup Options
- Assigning an Application Title
- Creating/Assigning an Icon
- Displaying a Form on Open
- Hiding the Navigation Pane
- What We Covered
- That's All Folks
-
Lesson Clips
- Introduction
-
Lesson Clips
- Introduction
- Integrating the Office Applications
- Importing Data
- Our Scenario
- Importing from Access
- Importing From Excel
- Creating a Named Range in Excel
- Importing from an Outlook Folder
- Importing from a Text File
- Exporting Data
- Exporting to an MS Word Table
- Exporting Using MS Word Mail Merge
- Exporting to MS Excel
- Exporting to a Text File
- Exporting as a PDF File
- Linking Data
- Linking to Other Access Table
- Linking to Excel
- Linking to Outlook
- What We Covered
-
Lesson Clips
- Introduction
- Overview Data Collection
- Set Up
- Fields You Can't Update Using E-mail
- Steps for Creating a Data Collection Email
- Creating a Data Collection Email
- Configuring Replies
- Managing Replies
- Viewing Messages in Outlook
- Viewing Messages in Gmail
- Viewing Replies
- What We Covered
-
Lesson Clips
- Introduction
- Help! I Have Tables that Aren't Normalized!
- The Table Analyzer Wizard
- Compacting a Database
- Analyze Performance
- Database Documenter
- Encrypting Your Database with a Password
- Unset a Password
- Splitting a Database
- 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.
