To provide the knowledge and skills required to develop databases with Access.
Programmers, analysts, designers and database administrators.
Knowledge of conceptual data modeling (Course BD101) and of Windows.
Highly appreciated training. The trainer is an excellent popularizer and listener.
Jean D. / Conseiller planification et optimisation, Hydro-Québec
Myrianne G. / Conseillère commercialisation, Hydro-Québec
- Strengths and weaknesses of MS Access: comparison with MS SQL Server
- Tables: modeling, structure, creating tables and fields, primary keys, relations and data validation
- Working with data sheets: usage, formatting, sorting and filters
- Importing and linking to external data
- Designing and using queries: simple queries, multiple table queries, action queries, parameter queries, crosstab queries and calculated fields
- Forms: types of forms, using the assistants, modifying forms and adding controls
- Designing and printing reports
- Managing the database: analysis and documentation, compacting and multi-user environment
- A look at the other capabilities of Access: macros, security and replication
Note: Although the course is given using Access 2010, the concepts covered can be applied to Access 2007.