Microsoft Access 2013 Database Training

Microsoft Access 2013 Training Training Course Microsoft® Access 2013 Training
By TED Integrated
Microsoft® Access:

Developing Application Database Using Microsoft® Access 2013

“Learn the concept of relational database in Microsoft® Access 2013 and its information management tools.”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
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
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions

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 ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,