Similarities between Access Databases and Projects

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)