create look-up table


A lookup table is a table that contains data that is referenced by another table. The other table will have a lookup field that can "lookup" the data in the lookup table.

In Access, the lookup field displays the data as a drop down list (or combo box) so that the user can select the desired value from the list. The values of the lookup field come directly from the lookup table.

We will now turn our Genres table into a lookup table. The Albums table will then have a lookup field that gets its values from the Genre table.

Screenshot of the Lookup Wizard option in Design View

Launch the Lookup Wizard

Open the Albums table in Design View.

In the GenreId field, click in the Data Type cell and select Lookup Wizard from the combo box.

The Lookup Wizard will appear.

Screenshot of the Lookup Wizard

Choose how the Lookup Field will get its Values

Leave the default option (I want the lookup field to get the values from another table or query.) selected and click Next >.

Screenshot of the Lookup Wizard

Choose the Field/s to display in the Lookup Field

You can choose which field will be displayed in the lookup field of the table referencing the lookup table.

Double-click Genre so that it moves to the right pane, then click Next >.

Screenshot of the Lookup Wizard

Choose the Sort Order for the Lookup Field

You can choose how the data will be sorted in your lookup field.

For this example, we will sort by the Genre field in ascending order.

Select Genre from the first drop down, then click Next >.

Screenshot of the Lookup Wizard

Select the Column Width of the Lookup Field

Access gives you the opportunity to specify the width of the column/s in your lookup field. If our field contained longer values, we might widen it, but the default width looks pretty good.

You can also choose to display or hide the lookup table's primary key column. Leave it hidden.

Click Next >.

Screenshot of the Lookup Wizard

Choose a Lable for the Lookup Field

You can provide a label for the lookup field. In our case, let's shorten it to Genre.

Also, check Enable Data Integrity.

Click Finish to generate the lookup table.

Screenshot of the Lookup Wizard

Save the Table

If you get prompted to save the table, click Yes and save it.

Screenshot of the Lookup Wizard

Check your Lookup Field

Your lookup table (and corresponding lookup field) has now been created.

Check your lookup field by switching to Datasheet View and clicking in the Genre field.



Comments

Post a Comment

Popular posts from this blog

vocab

Image
       Meaning vocabulary is a term that describes how people learn the meaning of words. Children can learn the meanings of words by using context clues, word part instruction and graphic organizers. Meaning vocabulary entails words for which their meanings are understood and it is an important component of comprehension. Direct instruction in meaning vocabulary is essential. If vocabulary is not developed, children will be unprepared to handle vocabulary demands of content-area subjects. Its significance is also displayed in comprehension and interaction with others. Meaning vocabulary helps to build social skills, confidence and self-esteem in children. It also enables children to use context clues to decipher word meaning. It helps children to construct more interesting stories and to communicate effectively with their peers and just about anyone with whom they interact. The more words they know, the more aptly they will be able to communi...
Read more

📚Gds-Tech 📚 EMS

Image
In this competitive world, 'Vocabulary' plays a vital role in every exam. Several banking and Government exams are round the corner like IBPS PO, Clerk, IBPS RRB, SSC-MTS, CGL, CHSL, State Level exams , Other Exams etc.  Gds-Tech Educational sollution  provide you 10 new words in  Gds-vocab  on the daily basis which will benefit you in upcoming examinations.  The Gds-Vocab  includes the word with the meaning, synonyms, antonyms along with the example given in  " The Gds Info-Skill Times "   pages. As we all Know in English section the vocabulary comes from THE HINDU Newspapers in the most bank and competitive exams and it is very essential to read and memories vocab from The Gds  Vocab daily. You can test your vocabulary and evaluate yourself with regard to your respective exams. You can easily learn The words form Gds  Vocab   regular basis .          Gds ...
Read more

spreadsheet in excel

Image
What is a Spreadsheet A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text,  formulas ,  references  and  functions . Rows, columns and cells in a spreadsheet The rows in a spreadsheet have numeric names (1, 2, 3 etc) and the columns have alphabetic names (a, b, c etc), thus the names of cells subsequently exist of a letter and a number that conveniently point out their position in the grid Selection of a row In the image above row 3 is selected. This can be done by clicking on the number 3 in front of the row. Selection of a column In the image above column B is selected. This can be done by clicking on the letter B above the column. Selection of a cell In the image above cell B3 is selected. This can be done by clicking on the cell. Worksheets A spreadsheet can contain one or several worksheets (tabs). Adding worksheets can be done by clicking the...
Read more