Designing, Building, and Using Databases(Beginning MS Access)


You are here: [Designing, Building, and Using Databases(Beginning MS Access) Home]

A course reader developed by the instructor is provided at no additional cost to accompany this course.

See what former students had to say about this course.

This course introduces the following, fundamental concepts:

  • Design database objects (tables, queries, forms, reports) based upon relational database theory
  • Apply RDBMS concepts to understand dependencies between objects through a unified application interface lens
  • Create queries, reports and charts to retrieve, manage, filter and analyze data
  • Deploy database normalization rules, set table properties, constraints and integrate complex functions to protect data integrity and ensure accurate input and output streams
  • Design targeted user interfaces to streamline data input and simplify user experience

On successful completion you will be able to apply these new skills:
  • Design basic databases using data normalization rules.
  • Create tables and setting properties and constraints.
  • Create table relationships (One-to-One, One-to-Many, Man-to-Many).
  • Design and create queries for viewing, sorting, filtering and analyzing data (Select, Total, Parameter, and Crosstab queries).
  • Design and create simple forms for data input.
  • Design and create simple reports for data output.
  • Using basic database functions in queries (Iif, Left, Right, InStr, Mid).
  • Create charts in forms and reports.

Prerequisites: Comfortable navigating in Windows environment, windows file management skills (Create folder, copy, move, rename files). Prior database knowledge helpful but not required.

Click here for more information