MS. Access

Part-I1/ 2^nd Term Semester                                            Diploma in information Technology

MS. Access

(Version 2007 and onward)

(PAPER-I1)

Total Th Hrs    40                                                                          Total Pr Hrs     80

Total Th Mks  50                                                                          Total Pr. Mks   100

1. DATABASE CONCEPTS

           

            What is data and Database?

1.1      Why use Electronic Database?

1.2      Tables and Relationships

1.3      One to One

1.4      One to Many

1.5      Many to many

1.3    Database Features

1.3.1        Attributes, Character Fielded

Record, Tuples Files

1.3.2        Key, Primary Key

Foreign Key, Composite Key

1.3.3        Referential Integrity

1.3.4        Use of Wild Cards

1.4    MS- Access (Database)

Ms-Access Use Access, Window

       Title Bar, Control Menu, Toolbar

       Status Bar

       Database Window

       Object button

       Data types

       Start Access

       Creating table, Table view

1.4.1        Create Table using in

Design View

Setting Primary Key, Saving table

Close, exit add, delete record filed

Resizing row column

Freezing Hiding Column, Finding Data

Repl data, Auto content, Spell checking

Create Tales using in Wizard

1.4.2        Create relationship between Tables

1.4.3        Create Queries, define query, use adv

Types of query

Creating simple query

Executing data

Join, Difference between relations and join

Extracting data

Use of query wizard

1.4.4        Create Forms, What is form

Types of form

Create form by wizard

Create form of Design View

Add new record through form

Edit record through form

Editing option

List Box, Combo Box

Adding list Box and Combo Box

Cheek Box and option button

Command Button

1.4.5        Create Reports

What is report?

Use of Report, Standard types report

Auto report

Saving and closing auto report

Create single table report

Create two table report

Create Report in design view

Print a report

1.4.6        Database Security

Reference Books / Helping Material.

1. Business Information Technology –II by Mohammad Khalid.
2. Modern Data Base System By Thomas Canolli