Microsoft Access Tips and Tricks for Creating Tables

Here are a few tips and tricks that I have found helpful1. Create a Make Table query including the field from
when working with tables in Microsoft Access.  Not allthe table that includes the new data
tips apply to all versions of Access.2. Run the query
Zoom3. Delete the original table and the table that held the
Click into the cell that you want to enter the data andnew data
press SHIFT F24. Rename the table that was created with the Make
Shortcuts for date and timeTable query so that is replaces the original table.
Current date CTRL; Current time CTRL:Sorting Multiple Columns in a Table
Right-align Text in a Table1. Re-order the fields that you want to sort on so that
Type * in the Format Property for that field.they are adjacent to each other and in the order you
want to sort by (left to right).
Carry Data Forward From One Record to the Next2. Highlight the fields that you want to sort by
In the field that you want to copy the entry from the3. Use the sort buttons on the toolbar
previous record in type CTRL’OR
Updating a Table with Information from Another TableUse an advanced filter.
To update data in an existing field – eg a newHide a Table
telephone list:The table’s name must start with Usys To view
1. Create an Update query and link the two tables withthe table again: Tools | Options [View] System Objects
a one-to-one relationshipCopy a table between databases
2. Add the field from your original table that needs toNormal copy and paste – then have the option to
be updatedpaste structure and data, just structure or append data
3. In the Update to row enter the followingto an existing table.
[New Table Name].[New Field Name]Custom Number Formats
4. Run the queryFour parts to the format, separated by semicolons.
To update a table with an entirely new field: