Microsoft has always remained in the limelight for its outstanding contribution in the world of computers. Microsoft introduced a bunch of sources for its users’ due to which we are compelled to depend on them to get our work done easily and precisely. From Windows 7, Vista, XP or 2000 edition as GUI (Graphical User Interface) to MS Office to get all entry, writing, designing and record maintaining work easier and simpler.
Let us pen down to MS Access, a member of MS office which an integral pseudo RDMS (Relational Database Management System) which combines with the relational MJDE (Microsoft Jet Database Engine) with aid of a GUI and development of softwares tools. MS Access is used to develop application softwares by developers or data architects. Moreover Power users’ can use MS Access to create applications like “Office Applications”, since MS Access is supported by Visual Basic and an OOP (Object Oriented Programming) language can work with it easily.
Now coming to, putting up the values from a table in to another. This task can be performed simply with the help of a “Lookup list”. Now just suppose yourself to be a Photoshop user, you will have one table for your photographs while the others as galleries which can display them. With the help of a Lookup list of galleries names, you can easily insert the Gallery table in to a field of your table one for photographs. You can simply click on the right name of gallery of your desired choice from the menu, instead of typing it using your keyboard. The same story applies in case of MS Access tables as follows.
Create a Lookup List from the Design View of MS Access.
Step one: MS Access table must be opened in the “Design View” form.
Step two: A new row must be inserted in the spot where you long to view your new field to appear. “First empty row” must be clicked on, if you long to your new field to appear at the end. Name the field created.
Step three: Immediately after the above step, you will see a data type box to your right and a small arrow will appear in the right corner. To view the menu of choices, click on the small arrow to view it. Amongst those options choose the “Lookup Wizard” tab.
Step four: The instance wizard appears, click on “I want the Look up Column to look up values in a table or query”. After following the instructions of the wizard, click on the “Finish” tab when you are satisfied completely.
Step five: Save the table being created. For the Datasheet view creation of table, you simply have to click on the empty field that will produce a menu of choices on the basis of the field values that you have skimmed through.
Thus, MS Access Look up values from one table can be automatically inserted in to another, by simply following above instruction to avoid cumbersome entry then after.