Developing a simple databases to elicit information
 


  • Overview of Database Applications

  • Overview of Relational Databases 

  • Business Example

  • Starting Access

Creating and Viewing Tables



  • Creating a Table Using the Design View

  • Exercise: Creating a Table 

  • Viewing and Adding Data to a Table

  • Exercise: Adding Data to a Table

  • Creating Relationships Between tables

  • Review of Creating and Viewing Tables 

Creating and Running Queries



  • Single Table Queries 

  • Multiple Table Queries 

Creating and Running a Data Entry Form



  • Creating a Single Table Form using the Wizard

  • Data Entry using Form

Creating and Running a Report 



  • Creating a Single Table Report using the wizard 

  • Running a Report

(c) Shilpa Sayura Foundation 2006-2017