Similarities between Access Databases and Projects
About indexes
Article About indexing fields and records in an Access database (MDB) About indexes (ADP)
About keys
Article About primary keys (MDB) About keys (ADP)
About queries
Article About types of queries (MDB) About select and crosstab queries (MDB) About action queries (MDB) About creating queries (ADP) ##Side:Start;Align:left## Tip …
About table relationships
Article About relationships in an Access database (MDB) About table relationships (ADP)
About tables
Article About tables (MDB) About tables (ADP)
Add columns to a query
Article Add or remove a field in the design grid (MDB) Add columns to a query (ADP)
Backup and restore an Access file
Article Back up and restore an Access database (MDB) Backup and restore a database or Access project (ADP)
Create a join in a query
Article Enable or disable automatic joins in queries (MDB) Join tables and queries in a query (MDB) Create a join between tables on multiple columns in a query…
Create a relationship between tables
Article Define relationships between tables (MDB) Create a relationship between tables (ADP)
Create an append query
Article Create an append query (MDB) Create an append query (ADP) ##Side:Start;Align:left## Tip Access 2010 includes improved tools and layout that help create…
Create an index
Article Index one or more table fields in Access 2003 by using the table designer.
Create an input mask
Article Create an input mask (MDB) Create an input mask (ADP)
Create an update query
Article Create an update query (MDB) Create an update query (ADP)
Delete a join in a query
Article Delete a join line in a query (MDB) Remove a join in a query (ADP)
Delete a relationship
Article Delete a relationship (MDB) Delete a relationship (ADP)
Delete an index
Article Delete a table index in Access 2003 by using the table designer.
Modify a join in a query
Article Set or change the join type (MDB) Change the type of join in a query (MDB) Modify a join operator in a query (ADP)
Run a query
Article Run a query (MDB) Execute a query in the Query Designer (ADP)
Total records in a query
Article Total records in a query (MDB) Count rows in a query (ADP) ##Side:Start;Align:left## Tip In Access 2010, you can calculate data directly in a table…
Troubleshoot queries
Article Troubleshoot queries (MDB) Troubleshoot queries (ADP)
