Data Base Development

Chapter 8: Data Base Development (37 videos)   (Practice Test)

8.1: Introduction

1. Introduction to MS-Access
2. MS-Access Window Description
3. Create Database Using Database Wizard
4. Database Objects

8.2: Working with Tables(Practice Test)

1. Creating a New Table
2. Field Properties in Design View 1
3. Field Properties in Design View 2
4. Field Properties in Design View 3
5. Field Properties in Design View 4
6. Field Data Types Available in Access
7. Multiple Tables and Relationships
8. Creating Primary Key in a table
9. Referential Integrity
10. Constraints in Relational Database

8.3: Working with Forms(Practice Test)

1. Using Navigation Button to create form
2. Addying Modifying and deleting Record
3. Advantages of Using Forms
4. Creating a Form using Wizard
5. Creating Form in a design view
6. Making Sub forms in Access
7. Form Appearance : Header and Footer
8. Adding a Logo
9. Using forms controls

8.4: Working with queries and commands(Practice Test)

1. Introduction to Queries
2. Planning a Query
3. Types of Queries : Select Query , Action Query
4. Creating the Query : Using Query Design Window
5. Using Simple Query Wizard
6. Selecting Records by Criteria
7. Creating an Update Query
8. Creating a Delete Query
9. Creating an Append Query
10. Creating a Make Table Query

8.5: Generating Reports

1. Purpose of Reports in Database
2. Creating Reports Using Report Wizard
3. Creating Reports Using Query
4. Formatting Reports