June 2011
Beginner
552 pages
14h 54m
English
Content preview from Microsoft® Access® 2010 24-Hour TrainerBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
13
Creating Value List Fields
Tables in Access often have fields that contain a value list of options for the user to choose from (instead of having users type the text). Access 2010 makes it very easy to create value list fields and even provides built-in dialogs to allow the user to update the values in the list. The values can be static and typed into the Row Source property of the lookup field, or from values that are either in a table or returned using a query as a data-driven list.
One of the main reasons for using a lookup field (data-driven list field) is to provide a method to increase the consistency of data being entered into a field. If the three choices allowed for a city name field for a retail outlet store are Tallahassee, Talladega, and Tuscaloosa, relying on the users' spelling skills will probably result in hundreds of spelling variations, making any searches for individual city names virtually impossible. Providing a drop-down list that includes only the correct options ensures that the correct spellings (and data formats) are used. This lesson discusses the various options for building list fields for tables using Access 2010.
LESSON SETUP
In this lesson, you learn how to create list fields using both value lists and values from tables or queries. The Lesson 13 files should be downloaded from the book's website to complete this lesson, and you should be familiar with creating database objects and working with tables.
LIST FIELDS IN ACCESS
Access has two list ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.