dbms Info Support Case studies Data demo Training
 
Access
Two day introduction
Designed for those with little or no previous database knowledge, some basic PC and Windows experience is required.
The objective of the course is for the delegates to gain a level of competency to create a multi table relational database that will be useful to your organisation.

Course Content
Database basics, design concepts
Creating select queries, with single or multiple criteria, the use of “wildcards”
Creating select queries to retrieve dates and numbers, using various operators
Designing a database table
Importing and linking tables, from Access and Excel
Investigation relationship and referential integrity
Action Queries
Calculations within a Query
Designing Forms for viewing and input of data, inserting Combo boxes and Command Buttons
Report design, inserting calculations and totals