Access 2000 - intermediate for developers
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
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.
Facilities
Location
Start date
Start date
Reviews
Course programme
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
-
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
- replication overview
- security
- activex controls in a form
- customise menus and toolbars
- de-duplicate records
Access 2000 - intermediate for developers