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
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
This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.