Database Management PLUS

MS Access with SQL Basics

Module 1:

RDBMS Concepts
Importing , creating external links and exporting data
o Building a database
o Database templates, creating and modifying table and building relational tables
Designing a database
o Fields and primary key, composite Key, Foreign Key
Relationships
o One to One, One to Many, Many to Many

Module 2:

SQL Basics:
o Sort, Retrieve And Analyze Data
Filter, queries to retrieve data, complex queries to modify data
o Work With Reports
Creating and modifying reports
o Manage An Access Database
Database security and database splitter.

Module 3:

Work With Forms - Creating and designing form and modifying properties