Excel in Access (Parts 1, 2 and 3 as Video Instructions)

Excel in Access

(Parts 1, 2 and 3 as Video Instructions)

…         ..         ..            ..        ..          ..           ..     ..  ..         … 

Convert an Excel "Contacts" Spreadsheet to MS Access

Convert an Excel "Contacts" Spreadsheet to MS Access

Video 1 (06:00)

Choosing the Data to Transpose Notes:-The video explores a table which is in “flat file” format, suggests how you can choose which rows and columns would possibly benefit from being transposed into a new table, then demo’s how to do this with the tool provided (A Form) Download:- Transpose Tool – Nifty Access

Video 1 (06:00)

Play Video

… …

Remove Redundant Data

Remove Redundant Data

Video 2 (03:23)

Notes:- Explains how to remove redundant data from the table produced above, identifies a field that would benefit from being converted into a lookup table, and shows how to create a look up table from this field.

Video 2 (03:23)

Play Video

… …

Setting up the "Lookup" Table

Setting up the "Lookup" Table

Video 3 (03:12)

Notes:- Using the above look up table demonstrates how to replace the “text data” with a number which links the former text (now in the look up table) with the original row/record.

Video 3 (03:12)

Play Video

… …

Create Datasheet Form

Create Datasheet Form

Video 4 (5:10)

Video 4 (5:10) Notes:- demonstrates how to create a form in datasheet view, and add a combo box to display the look up data

Video 4 (5:10)

Play Video

… …

Display the Data in a Subform

Display the Data in a Subform

Video 5 (4:00)

Notes:- and then display that form as a sub form showing the telephone number, communication media list, as related to the contact

Video 5 (4:00)

Play Video

… …