Access 2003 - intermediate for developers
Course
In London
£ 490
+ VAT
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
Facilities
Location
Start date
London
See map
210 Borough High St, SE1 1JX
Start date
On request
Reviews
Have you taken this course?
Course programme
course description
after completing this course, participants will be able to:
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 2003 - intermediate for developers
£ 490
+ VAT