Home
Sabaq Lite
About Us
Media
Sign In
Sabaq Foundation
Sabaq Lite
About Us
Media
Sign In
Microsoft Access 2007
Federal Board > Class 11 > Computer Science (
Total Videos: 80
)
All Chapters
Chapter 1: Computer Hardware
Chapter 2: Microsoft Access 2007
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
)
Introduction to MS-Access
Benefits of Using Access
Create Database Using Database Wizard
Create Database without Using Database Wizard
MS-Access Window Description
2.2: Creating tables and Assigning Primary key to the table
Creating a New Table
Creating Primary Key in a table
2.3: Adding Records to a Table and Modifying Records in a table
Addying Modifying and deleting Record
2.4: Creating Relationship between tables (one- to - one ) Relationship
Degree of a Relationship
2.5: Creating One to Many Relationship
Referential Integrity
2.6: Creating Many-to-Many Relationship
Cascade Update Related Fields and Cascade delete RF
2.7: Creating Queries
Introduction to Queries
Planning a Query
2.8: Viewing and Running Query
Using Simple Query Wizard
2.9: Modifying Query
Selecting Records by Criteria
2.10: Multiple table Queries
Multiple Tables and Relationships
2.11: Adding a Calculating Column/Field to a Query
Selecting Records by Criteria
2.12: Creating Queries using Query design
Creating the Query : Using Query Design Window
2.13: Creating a Make table Query
Creating a Make Table Query
2.14: Creating an Append Query
Creating an Append Query
2.15: Creating an Update Query
Creating an Update Query
2.16: Creating a Delete Query
Creating a Delete Query
2.17: Creating and Runnig Data Entry form
Using Navigation Button to create form
2.18: Making forms more usable with Controls
Using forms controls
2.19: Creating form with Sub form for related tables
Making Sub forms in Access
2.20: Creating a Switch Board form
Creating a SwitchBoard in Access
2.21: Generating Reports
Purpose of Reports in Database
Creating Reports Using Report Wizard
Formatting Reports
2.22: Creating a Report Using Query
Creating Reports Using Query
Spread the word:
Tell us how Sabaq videos have helped you?
Click here
Facebook
Twitter
Instagram
Youtube
Linkedin