MS Access: Tables

Basics

• Create a table in Access 2007
• Open a table in Design view in Access 2007
• Open a table in Datasheet mode in Access 2007

Navigation Pane (2010 and 2007)

• Display tables in the Navigation Pane in Access 2007
• Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2013 | 2010 | 2007
• Display tables and related objects in the Navigation Pane in Access 2007

Hide / Unhide tables

• Hide tables as hidden objects in Access 2007 | 2003
• Hide tables as system tables in Access 2007 | 2003
• View system tables in Access 2007 | 2003
• View hidden tables in Access 2007| 2003

Linked Tables

• Link to a table in another database in Access 2013 | 2007 | 2003
• Refresh table links in Access 2007 | 2003
• Access does not recognize table changes to linked tables in Access 2003
• Linked table record shows as deleted (ie: #DELETED) in Access 2003
• Link to an Oracle table using VBA code in Access 2003

Imported Tables

• Import a table from another database in Access 2007 | 2003
• Import table record shows as deleted (ie: #DELETED) in Access 2003

Sequential numbers

• Create an auto-increment field in a table in Access 2007 | 2003
• Create a sequential number that you can control instead of using an AutoNumber field in Access 2003
• Create a sequential number that you can control using a format such as AGR-0001 in Access 2003
• Create a sequential number that you can control using a format such as A05-0001 in Access 2003
• Create a sequential number that you can control using a format such as OD00000001 and generate multiple records at once in Access 2003
• Create a sequential number you control that is assigned every time a form is opened in Access 2003

Miscellaneous

• Create a random number field in a table in Access 2007 | 2003
• When a record is deleted in a parent table, the child records are deleted also in Access 2003
• Reset the counter on a AutoNumber field in Access 2003
• Find next incremental value for an AutoNumber field in Access 2003
• Indexes on a table in Access 2007 | 2003
• Define a custom format for a Date/Time field in a table in Access 2007 | 2003