Microsoft Access 2013 Database Training

Microsoft Access 2013 Training Training Course Microsoft® Access 2013 Training
By TED Integrated
Course Title:
Developing Application Database Using Microsoft® Access 2013
Training Category:
Information Technology
Target Audience:
Anyone who are interested to use Microsoft Access as light-weight database for application development and to learn some basics of relational database.
Duration:
2 Days

Course Introduction ›

One of the most efficient and powerful information management approaches used by many software and web applications is Relational Database. It helps to manage large amount of information for a company to facilitate application development and produce meaningful reports. Data can be stored, linked, and managed using a single relational database application and its associated tools.

In this 2-day training course, you will be introduced to the concept of relational database in Microsoft® Access 2013 and its information management tools.

Course Objectives ›

By the end of this Microsoft Access course, participants should be able to:

  • Understand the concepts of database
  • Manage the data in a database.
  • Examine existing table relationships.
  • Query the database.
  • Design simple forms.
  • Create and modify access reports

Course Outline ›

DAY 1

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
DAY 2

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

Contact us now ›

Related Courses ›

Published by: ,