Microsoft Access 2007

Chapter 2: Microsoft Access 2007 (30 videos)   (Practice Test)

2.1: Starting Microsoft Access(Practice Test)

1. Introduction to MS-Access
2. Benefits of Using Access
3. Create Database Using Database Wizard
4. Create Database without Using Database Wizard
5. MS-Access Window Description

2.2: Creating tables and Assigning Primary key to the table

1. Creating a New Table
2. Creating Primary Key in a table

2.3: Adding Records to a Table and Modifying Records in a table

1. Addying Modifying and deleting Record

2.4: Creating Relationship between tables (one- to - one ) Relationship

1. Degree of a Relationship

2.5: Creating One to Many Relationship

1. Referential Integrity

2.6: Creating Many-to-Many Relationship

1. Cascade Update Related Fields and Cascade delete RF

2.7: Creating Queries

1. Introduction to Queries
2. Planning a Query

2.8: Viewing and Running Query

1. Using Simple Query Wizard

2.9: Modifying Query

1. Selecting Records by Criteria

2.10: Multiple table Queries

1. Multiple Tables and Relationships

2.11: Adding a Calculating Column/Field to a Query

1. Selecting Records by Criteria

2.12: Creating Queries using Query design

1. Creating the Query : Using Query Design Window

2.13: Creating a Make table Query

1. Creating a Make Table Query

2.14: Creating an Append Query

1. Creating an Append Query

2.15: Creating an Update Query

1. Creating an Update Query

2.16: Creating a Delete Query

1. Creating a Delete Query

2.17: Creating and Runnig Data Entry form

1. Using Navigation Button to create form

2.18: Making forms more usable with Controls

1. Using forms controls

2.19: Creating form with Sub form for related tables

1. Making Sub forms in Access

2.20: Creating a Switch Board form

1. Creating a SwitchBoard in Access

2.21: Generating Reports

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

2.22: Creating a Report Using Query

1. Creating Reports Using Query