1DCA3(B) – DATABASE USING MS ACCESS

UNIT-I

Introduction to database -What is a Database, Why use a Relational Database, concept of primary key relationship, Introduction to MS Access (Objects, Navigation).

UNIT-II

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

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, 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

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

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.