Access Your Data with MS Access Notes

Key Links and Information

Discontinued features and modified functionality in Access 2013

Access 2010 web database creation
Access Data Projects (ADP)
Access support of Jet 3.x IISAM
PivotCharts and PivotTables
Text and Memo data types
dBASE support removed from Access
Smart Tags property
Access Data Collection
Access 2003 toolbar and menus
Access Replication Options
Access Source Code Control
Access Three-State Workflow
Access Upsizing Wizard
Access Package Solution Wizard

Guide to table relationships
"One of the goals of good database design is to remove data redundancy (duplicate data). To achieve that goal, you divide your data into many subject-based tables so that each fact is represented only once. You then provide Access with a way to bring the divided information back together — you do this by placing common fields in tables that are related. To do this step correctly, though, you have to understand the relationships between your tables, and then specify these relationships in your database."