Microsoft Access

About This Course

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics.

Most job roles today involve some form of data management. In the case of data workers, it may be their primary job task. For some, such as research scientists and accountants, data management may be a strong component of the job. And for others, such as sales clerks or those in the skilled trades, data management may consist of an incidental job responsibility, for example, time reporting or recording a sale. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft Office Access can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

Microsoft Access Level 1 ( 1 day)

1. The Basics

  • Getting Started
  • Signing In
  • Creating a Database
  • Database Terminology
  • Saving a Database
  • Opening a Database

2. Your First Database

  •  About Security
  • Warnings   
  • About Relationships
  • Searching for Objects
  • Opening Database Objects
  • Changing the Object View
  • Understanding the Types of Views Available

3. Working with Tables and Records

  • Creating a Table
  • Understanding Table Views
  • Adding and Editing Records
  • Searching and Browsing Records
  • Deleting Records
  • Printing Records

4. Formatting Tables

  • Selecting Data
  • Changing Column and Row Width and Height
  • Applying Text Formatting
  • Applying Gridlines
  • Changing Fill Colors
  • Checking Your Spelling

5. Creating Forms

  • Creating a Form from an Object
  • Creating a Form with the Wizard
  • Creating a Form from Scratch
  • Understanding Form Views
  • Using a Form

6. Formatting Forms

  • Understanding Bound and Unbound Controls
  • Changing the Theme
  • Using the Format Painter
  • Adding Fields
  • Adding Controls
  • Adding Images and Logos
  • Review Questions

7. Creating Reports

  •  Creating a Report from an Object
  • Creating a Report with the Wizard
  • Creating a Report from Scratch
  • Understanding Report Views
  • Printing Reports

8. Formatting Reports

  • Changing the Theme
  • Using the Format Painter
  • Grouping and Sorting Data
  • Adding Controls
  • Adding Images and Logos
  • Adding Page Numbers, Headers, and Footers

9. Creating Basic Queries

  • Types of Queries
  • Creating a Query with the Wizard
  • Running a Query
  • Understanding Query Views
  • Sorting and Filtering a Query

10. Creating Advanced Queries

  •  Creating and Using Parameter Queries
  • Creating and Using Crosstab Queries
  • Creating and Using Make-Table Queries
  • Creating and Using Multiple Table Queries
  •  Creating and Using Append Queries
  • Creating and Using Delete Queries
  • Creating and Using Update Queries

11. Managing Your Database

  • Compacting and Repairing a Database
  • Encrypting a Database with a Password
  • Backing Up Your Database
  • Exporting a Database and Database Objects
  • Printing Database Objects

12. Customizing the Interface

  • Collapsing and Pinning the Ribbon
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Microsoft Access level 2 (1 day)

1. SQL and Microsoft Access

  • Importing Information
  • Exporting Information
  • Copying o and from Other Office Programs

2. Using the SELECT Statement

  • Selecting All Data
  •  Selecting Specific Data
  •  Selecting Conditional Data
  •  Using the ORDER BY Statement

3. Using SQL Joins

  • Creating Simple Joins
  •  Using an Alias
  •  Sorting Joins
  •  Creating Outer Joins

4. Using Subqueries

  • What is a Subquery?
  •  Creating a Subquery
  •  Subqueries with Aggregate Functions and Nested Subqueries
  •  Using the IN Keyword with Subqueries

5. Advanced Form Tasks, Part One

  • Limiting User Access to a Form
  •  Creating Checkboxes and Command Buttons
  •  Building Command Button Events
  •  Creating Event Procedures

6Advanced Form Tasks, Part Two

  • Using Hyperlinks in a Form
  • Adding Links to Other Database Objects
  • Inserting a Mailto Link in a Form
  • Adding a Browser Control to a Form
  • Performing Calculations in a Form

7Advanced Form Tasks, Part Three

  • Exporting Your Form to XML
  • Exporting a Form as a Word Document
  • Exporting a Form as HTML
  • Sending a Form as an E-mail Attachment
  • Exporting a Form to Other Formats

8. Creating Split Forms

  • Creating a Split Form
  • Splitting an Existing Form
  • Using a Split Form
  • Fixing the Form Separator

9.Using Digital Signatures

  • What is a Digital Signature?
  • Obtaining a Digital Signature
  • Attaching Your Signature to a Database
  • Extract and Use a Signed Database

10. Using the Trust Center

  • Opening the Trust Center
  • Trusting a Database
  • Configuring Macro Security
  • Customizing the Message Bar

11. Managing COM Add-ins

  • Viewing Add-ins
  • Opening the Add-in Manager
  • Installing Add-ins
  • Disabling All Add-ins
  • Uninstalling Add-ins

12Customizing Access

  • Changing User Information
  • Changing the Office Background and Theme
  • Setting the Default Database Type and Location


The Access training is aligned to the Microsoft Office Specialist certification. 


Preview This Course

This Course Include