UpcomingAccess 2013 Level 1

Rosalina Legaspi

We're sorry, but all ticket sales have ended.
  • August 20, 2018
    8:30 am - 4:00 pm

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)                        Instructor Led Training

Course Overview
This workshop covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more.

Course Content

Module 1: The Basics
Getting Started
Signing In
Creating a Database
Database Terminology
Saving a Database
Opening a Database
Module 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
Managing Objects
Module 3: Working with Tables and Records
Creating a Table
Understanding Table Views
Adding and Editing Records
Searching and Browsing Records
Deleting Records
Printing Records
Module 4: Formatting Tables
Selecting Data
Changing Column and Row Width and Height
Applying Text Formatting
Applying Gridlines
Changing Fill Colors
Checking Your Spelling
Module 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
Module 6: Formatting Forms
Understanding Bound and Unbound Controls
Changing the Theme
Using the Format Painter
Adding Fields
Adding Controls
Adding Images and Logos
Module 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
Module 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
Module 9: Creating Basic Queries
Types of Queries
Creating a Query with the Wizard
Running a Query
Understanding Query Views
Sorting and Filtering a Query
Module 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
Module 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
Module 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
Rosalina LegaspiUpcomingAccess 2013 Level 1