Microsoft Access
is used by small businesses and within departments of large organisations to
create customized systems for storing, processing and reporting information.
Microsoft Access enables a relatively quick development because all
tables, queries, forms, and reports are stored in the one database.
From Novice to expert, Microsoft Access allows system development to
be within the reach of the user.
Our training Allows you to capitalise on this
extremely useful and mostly under utilized resource. Our standard
Intermediate
course is outlined below but we can discuss bespoke courses and also
collaborative development of any database you wish to create.
Microsoft Access
Intermediate Training Course
|
Relational databases
Database normalization
Relating MS Access tables
Implementing referential integrity
Working with related
tables
Lookup fields
Modifying Lookup fields
Subdatasheets
Complex queries
Joining tables in MS
Access queries
Creating calculated fields
Summarizing and grouping values
Advanced form design
Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
|
Advanced reports
Customized headers and
footers
Adding calculated values
Sub-reports
Charts
Charts in forms
Charts in reports
PivotTables and
PivotCharts
MS Access PivotTables
Modifying PivotTables
PivotCharts
Internet integration
Hyperlink fields
Working with data access pages |
|
