Course Details

You will learn the Database system in depth through the below stated areas: What are Databases?

How to start and open an existing database?

Staring working with MS Access

Differences between datasheet and design view

How to use mouse pointer to navigate?

How can you use keyboard to navigate?

How can you develop and use Query?

How to create and run a query?

How to specify criteria in a query?

How to use comparison operators?

The secret behind creating a calculated field

Developing multiple-table queries

How can you print a query?

How to create and modify tables?

How to get started with creating a database?

How can you design a Table by Using the Wizard?

The process behind creating and modifying a table

How to go about adding fields to tables?

How can you add and edit records?

What to do when printing tables?

How to move and delete fields?

How to delete existing records?

How can you design a form?

How to create a form by using AutoForm and Form Wizard?

How to add controls to a form?

How to change control properties?

How to resize and move controls?

The process of entering records into a form

Designing calculated controls

How to get started on working with Tables?

How to format a table?

Steps required to modifying field properties

How to sort records in a table?

Finding specific records in a table

Utilizing filters in a table

How can you establish relationships between tables?

How to develop and design sub datasheets?

How can you import records from an external source?

Getting started with designing a report