Microsoft Access 2007

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

2.1: Starting Microsoft Access (Practice Test)

Introduction to MS-Access
239 views

Benefits of Using Access
7 views

Create Database Using Database Wizard
446 views

Create Database without Using Database Wizard
15 views

MS-Access Window Description
176 views

2.2: i. Creating tables ii. Assigning Primary key to the table, Saving the table (Practice Test)

Creating a New Table
136 views

Creating a Primary Key in a table
47 views

2.3: i. Adding Records to a Table ii. Modifying Records in a table (Practice Test)

Addying Modifying and deleting Record
40 views

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

Degree of a Relationship
166 views

2.5: Creating One to Many Relationship (Practice Test)

Referential Integrity
129 views

2.6: Creating Many-to-Many Relationship (Practice Test)

Cascade Update Related Fields and Cascade delete RF
14 views

2.7: Creating Queries (Practice Test)

Introduction to Queries
57 views

Planning a Query
28 views

2.8: Viewing and Running Query (Practice Test)

Using Simple Query Wizard
31 views

2.9: Modifying Query (Practice Test)

Selecting Records by Criteria
22 views

2.10: Multiple table Queries (Practice Test)

Multiple Tables and Relationships
127 views

2.11: Adding a Calculating Column/Field to a Query (Practice Test)

Selecting Records by Criteria
22 views

2.12: Creating Queries using Query design (Practice Test)

Creating the Query: Using Query Design Command
358 views

2.13: Creating a Make table Query (Practice Test)

Creating a Make Table Query
24 views

2.14: Creating an Append Query (Practice Test)

Creating an Append Query
22 views

2.15: Creating an Update Query (Practice Test)

Creating an Update Query
18 views

2.16: Creating a Delete Query (Practice Test)

Creating a Delete Query
14 views

2.17: Creating and Runnig Data Entry form (Practice Test)

Using Navigation Button in to create form
47 views

2.18: Making forms more usable with Controls (Practice Test)

Using form controls in MS Access
41 views

2.19: Creating form with Sub form for related tables (Practice Test)

Making subforms in Access
84 views

2.20: Creating a Switch Board form (Practice Test)

Creating a SwitchBoard in Access
14 views

2.21: Generating Reports (Practice Test)

Purpose of Reports in Database
48 views

Creating Reports Using Report Wizard
112 views

Formatting Forms and Reports
30 views

2.22: Creating a Report Using Query (Practice Test)

Creating Reports Using Query
37 views