Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2010 Essential Training

via LinkedIn Learning

Go to class Write review

Overview

Gives a comprehensive overview of creating databases in Access, whether using predefined database templates or building from scratch.

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Access Basics
  • Database concepts and terminology
  • Starting Access
  • Creating a new file
  • Trusting a file
  • The Quick Access toolbar
  • Backstage view
  • Exploring ribbons
  • Using the Navigation pane
  • Getting help
2. Creating a First Database and Using the Tools
  • Planning and designing your database
  • Creating tables using Application Parts
  • Creating tables in Layout view with Quick Start
  • Creating and editing tables in Design view
  • Setting a primary key
  • Creating a lookup field
  • Creating multi-value fields
  • Using calculated fields
3. Setting Up the Data
  • Setting field properties
  • Setting input masks
  • Setting validation rules
4. Building Structure
  • Creating relationships and enforcing referential integrity
  • Viewing subdatasheets
5. Formatting and Appearance
  • Entering data into your tables
  • Formatting tables
  • Finding, sorting, and filtering records
6. Forms
  • Creating data-entry forms
  • Using the Form Wizard
  • Modifying a form in Layout view
  • Using Design view
  • Setting tab stops
  • Adding buttons to a form
  • Using navigation forms
7. Queries
  • Introduction to queries
  • Using the Query Wizard
  • Creating a query in Design view with criteria
  • Creating wildcard queries
  • Creating reusable parameter queries
  • Creating yes/no queries
  • Creating "and" and "or" queries
  • Building calculation queries
  • Creating statistical queries
  • Using update queries
  • Using delete queries
  • Creating crosstab queries
8. Reports
  • Introduction to reports
  • Using the Report Wizard
  • Formatting reports in Layout view
  • Identifying report structure in Design view
  • Adding group and sort capabilities to a report
  • Adding existing fields from other tables
  • Adding totals and subtotals to a report
  • Adding conditional formatting and data bars to a report
  • Creating multi-table reports
  • Creating mailing labels
  • Printing reports
9. Putting Data to Work
  • PivotTables
  • PivotCharts
10. Automating with Macros
  • Creating macros
  • Attaching macros to objects
  • Using data macros
11. Using Other Applications with Access
  • Importing Excel and text data
  • Exporting data into Excel
  • Exporting to PDF
  • Exporting into a Word Mail Merge
  • Publishing to a web browser in HTML or XML
  • Sharing via email
  • Collecting data over email
  • Using Package and Sign
  • Publishing to SharePoint
  • Importing and exporting with SharePoint
12. Advanced Tools in the Database
  • Compacting and repairing a database
  • Using data analysis tools
  • Encrypting a database and setting a password
  • Splitting a database
13. Customization
  • Customizing the ribbons
  • Setting Access options
Conclusion
  • Goodbye

Taught by

Alicia Katz Pollock

Reviews

Start your review of Access 2010 Essential Training

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.