Access 2002 (xp) - intermediate for developers

course description
after completing this course, participants will be able to:

• create a well-designed database reflecting the needs of their users
• organise the tables with useful relationships to simplify development and operation
• use the field properties of a table to control accuracy and look of the data and speed retrieval
• create forms linked to more than one table
• modify form layouts quickly and effectively
• create user-friendly forms to speed up and simplify operations
• analyse and modify data using various query features and functions
• create customised reports to improve data analysis
• import and export data using a variety of methods
• understand how to share a database across a network using replication
• secure a database to prevent unauthorised access
• customise menus and toolbars to simplify operations
• identify and remove duplicated records
• incorporate an activex calendar control in a form to simplify operation

topic

• access essentials
  • database design concepts
  • normalisation - make a database more efficient; split tables into two or more tables to avoid duplicating data entry and data entry errors
  • table properties - validation, format, input mask
  • form and sub-forms, form design - quick methods using, for example, automatic alignment
  • add functionality to forms e.g. look up form - combo box wizard, sort by query
  • adding controls to forms (combo box, command button) and modifying properties (company d/b - dates in employees)
  • queries - calculating, wildcards, summary (totals), crosstab
  • action queries - delete, append, make table, update
  • reports - parameterise, grouping, exporting to word and excel
  • import data from excel and .csv files, paste errors, data validation violations
  • switchboard forms using command button wizard