| |
1. Introduction To MS Access
- Startup of MS Access
- Quitting MS Access
2. Database Concepts
- Examples of Database
- Six Types of Database Objects
-
Open a database
3. Table
-
What is Table?
-
Opening an Existing Table
-
Opeing Table in Datasheet View
-
Opening Table in Design View
-
When to use Datasheet/Design View?
-
Standard Table by Table Wizard
-
Designing a Customized Table
-
Setting Up Field
-
Setting Up Data Type
-
Setting Up Properties
-
Setting Up Field, Data Type & Properties by Expression Builder
-
Add/Delete/Move a Field
-
Setting Up Primary Key
-
Setting Up Index
-
Setting Up relationships
-
Add, Edit, Delete Record
-
Copy, Move Data
-
Find, Replace, Filter, Sort Data
-
Change datasheet layout
-
Set Up Table with Existing Data
4.Query -
What is Query?
-
Run a Query
-
Types of Queries
-
Creating Query
-
Standard Query by Query
-
Wizard
-
Designing a customized Query
-
Setting Up Type of Query
-
Select Query -Crosstab , Make-table , Update , Append , Delete , Union , through , definition
-
Setting Up Table, Query
-
Setting Up Join
-
Setting Up Fields
-
Other Options-specify criteria, sort records, calculate totals, set properties
5.Form -
What is Form?
-
Open a Form
-
Creating a Form
-
Standard Form by Form Wizard (AutoForm)
-
Designing a Customized Form , Customize or delete a control , Enhancing Form-title, page number, header & footer , Subform, Entry - Specify condition
6.Report -
What is Report?
-
Open a Report
-
Creating, Modifying a Report
-
Standard Report by Report Wizard (AutoReport)
-
Designing a Customized Report, Customize or delete a control, Report - title, page no, header & footer , Sort, Group records/ Calculate totals, averages
7.Relational Database
8.Exchange data -
Import or link data
-
Import or link Microsoft Foxpro or Dbase files
-
Import or link data from a spreadsheet
-
|
