1PGDCA3(B) – DATABASE USING MS ACCESS

UNIT-I

Introduction to database -What is a Database, Why use a Relational Database, Overview of Database Design- Data Normalization (Determining tables, Determining Fields, Determining Relationships) Integrity Rules (Primary/Foreign Key, One-to- Many, Many-to-Many, One-to-One) Introduction to MS Access (Objects, Navigation).

UNIT-II

Tables in Database, Create a Table in MS Access- Data Types, Field Properties, Fields: names, types, properties- default values, format, caption, validation rules Data Entry, Add record delete record and edit text, Sort, find/replace, filter/ select, rearrange columns, freeze columns. Edit a Tables- copy, delete, import, modify table structure, find, replace.

UNIT-III

Working with Query, Setting up Relationships- Define relationships, add a relationship, set a rule for Referential Integrity, change the join type, delete a relationship, save relationship Queries & Filter – difference between queries and filter, filter using multiple fields AND, OR, advance filter Queries, create Query with one table, find record with select query, find duplicate record with query, find unmatched record with query, run query, save and change query.

UNIT-IV

Working with Forms, Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, Main/Subforms, add headers and footers, add fields to form, add text to form use label option button, check box, combo box, list box Forms Wizard, Create Template.

UNIT-V

Working with Reports, Introduction to Reports, Types of Basic Reports: Single Columns, Tabular Report Groups/Total, single table report, multi table report preview report print report, Creating Reports and Labels, Wizard.