Microsoft Access 2007

Khyber Pakhtunkhwa Board > Class 11 > Computer Science (Total Videos: 80)

Show Content

Select a chapter above and press 'Show Content'. Click a video topic below to view.

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: i. Creating tables ii. Assigning Primary key to the table, Saving the table  (Practice Test)
  1. Creating a New Table
  2. Creating Primary Key in a table
2.3: i. Adding Records to a Table ii. 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  (Practice Test)
  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  (Practice Test)
  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