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

6. Advanced 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

7. Advanced 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

12. Customizing Access

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

Certification

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

Requirements

Preview This Course