Developing Application Database Using Microsoft^® Access 2013

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.

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

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

• Microsoft® Access 2010/2013 Intermediate
• Microsoft® Access for Intermediate / Advanced Level
• Business Intelligence with Microsoft® Excel 2010 & PowerPivot – Level 2
• Microsoft® Excel 2010: Task Automation with VBA Using Macro
• Integrating Microsoft® Excel Power Query Technology
• More other Information Technology related courses