Certificate in Office Administration
Ms-Access
Chapter No
Topics
1
INTRODUCTION TO DBMS AND RDBMS
  • Schemas, Instances, and Database State
  • Database Management System
  • Relational Database Management System
  • Primary key and Foreign Key
  • Normalization

2
INTRODUCTION TO MICROSOFT ACCESS 2003
  • Parts of Access Screen.
  • Parts of Access Screen.
  • Data Type in Ms-Access 2003
  • Field Properties

3
MORE ON ACCESS 2003
  • Input Mask

4
WORKING WITH DATABASE AND FORMS IN MS-ACCESS 2003
  • Entering data in the database
  • Sub forms and its advantages
  • Form View and Datasheet View

5
QUERYING AND WORKING WITH DATABASE
  • Sorting the Database
  • Specific Queries
  • Structured Query in Access
  • Some Basic SQL queries

6
REPORTS IN MS-ACCESS 2003
  • Reports
  • Saving a Report
  • Some more New Reports

7
RELATIONSHIPS IN MS-ACCESS 2003
  • Using related tables
  • Setting relationships

8
IMPORTING FILES IN ACCESS 2003
  • IMPORTING FILES IN ACCESS

9
CUSTOMIZING OPTIONS
  • Access 2003 Options
  • Setting Tables/Queries Options
  • Creating a toolbar

Certificate in Office Administration

Top