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)
… …
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)
… …
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)
… …
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)
… …
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)
… …
