Access 2000 training - what's new for Access 2000
The main innovation of Access 2000 was data access pages - a mechanism for publishing tables of data on web sites. Specific changes include:
| Change | Details |
|---|---|
| Data access pages | Data access pages allow you to publish tables of data on a web page. However, they create strange HTML full of Microsoft-specific commands, and we prefer doing things properly using Active Server Pages or ASP.NET. |
 |
|
| Projects | If you work with SQL Server, you'll love projects. They allow you to use forms, reports, macros and modules using SQL Server as your data source. The diagram below shows an Access project - notice the different object types on the left hand side of the database window. |
 |
|
| Subdatasheets | These allow you to see data from two related tables in the same datasheet. |
 |
|
| Fixing errors | Access cascades name changes (when you rename a field in a table, all the forms update). In theory at any rate … in practice you need to wait till Access 2003 for proper error-checking. |
| Printing relationships | You can now print out your relationships |
 |
|
| Grouping objects | You can now groups tables, queries, forms, etc together into groups - a useful idea which does not seem so useful in practice. |
 |
|
| Grouping controls | You can now group controls together - in the diagram below, 3 labels and 3 textboxes are being treated as a single control |
 |
|
| Conditional formatting | You can now apply conditional formatting to continuous forms |
You can view a full list of changes in recent versions of Microsoft Access by returning to our main Microsoft Access version history page.
