Microsoft Access
Presentation

Acces is the relational database system created by Microsoft and included in the Office suite.
 
Proposal for a content
  • Introduction to relational databases
    • How to create a relational database ?
    • Primary key
    • Relationship
  • Introduction to Access
    • The different objects in an Access relational database
  • Creation of tables
    • Data types
    • Properties
  • The queries
    • Simple queries
    • Queries with parameter
    • Groups
    • Calculated fields
    • Action queries
  • The forms
    • Format a form
    • Using controls (list, buttons,...)
  • The reports
    • Using the report wizard
    • Modifying the layout

     

    For advanced Access
  • The relationships
    • Referential integrity
    • Join properties
  • The analysis tools
  • Working with other applications
    • Summary
    • Import data
    • Export data
  • Introduction to SQL (query language for databases)
    • Introduction
    • Some elements
    • Some commands
  • The macros
    • Special macros: Autoexec and Autokeys
    • Link with an event
    • Group of macros
    • Conditional macros
  • Sécurity
    • Principle
    • A password for the database
    • Creating working groups
    • Defining security for users and groups
    • Delete the security
    • Using the MDE file
  • Working on a network
    • Sharing the database
    • Working with updates priorities
 
Practical info
  • The training is given with exercices based on the standard Access database called Northwind
  • Versions: Access 2, 95, 97, 2000 and XP
Back to the list of trainings