Microsoft Access | Ali Asjad Trainings

Microsoft Access for Business Professionals

Microsoft Access is an excellent tool for creating bespoke systems that have a database at their heart. It includes various wizards to speed up the process of creating a database application, and a vast array of readily available functionality. The development time is also very short. Access is the easiest tool to use to make a simple database, so is an excellent starting point for an enthusiastic user. You can also use Microsoft Access for data analysis as well. For developing small systems, Microsoft Access is a good option.

Introduction

Introduction To Database Development Environment
Basic Terminology
Linking Excel Data with Access and Generating Reports

Storing Information in Table

Building Smart Tables
Datasheet sorting, searching and filtering
Blocking Bad Data
Linking Tables with Relationships

Forms

Form Tools
Common Design Elements
Working In The Design Window
Modifying Form Sections and Controls
Designing and Using Sub forms

Designing Queries

Types of Queries
Creating Queries
Adding Selection Criteria
Performing Calculations
Creating Special Queries

Creating Custom Reports

Creating Report
Grouping Data
Sort Order
Summary Options
Layout, Style
Report Design

Advance Forms, Queries and Reports

Multi page Forms
Designing Action Queries
Union Queries
Report Based on Multiple Criteria and Summarization Options

Database Tools

Move Data and Database Tools
Password
Addins
Switchboard Manager, MDE File
VBA

Building Multi User Application

Administer Access Database
User and Permissions
Group Permissions and Accounts
Replication Options
Splitting Database