0
How do you create a drop-down field on a table in Microsoft Access?
Wiki User
∙ 14y ago
To create a drop-down field on a table in Access, you can do this:
1. Open the table in design view.
2. If you haven't already, create the field and specify its characteristics on the 'General' tab(i.e. data type, field size, etc...). The tab is in the lower-half of the screen.
3. Select the field you wish to make as a drop-down.
4. There is another tab next to 'General' named 'Lookup'. Click on that.
5. Set the following Field Properties as follows:
a. Display Control: Combo Box
b. Row Source Type: Value List
c. Row Source: Here you can enter a list of acceptable values, separated by a semicolon. Example: if you want the user to specify from 3 choices (such as A, B or C), you'd enter: A;B;C.
d. Limit To List: Yes - recommended if you don't want the user to enter values other than what you've defined above.
As a minimum, this info may be enough to get your started. Note that this info comes from Office 2007 and your version may be different, thus some options may not be available.
Hope this is enough to start you off. Keep in mind, there is always more than one way to do what it is you ask. Good luck!
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
In Microsoft Access what is an attribute?
An attribute would refer to a field in the tables that you create in Access.
What skills are required in order to create a database using Microsoft Access?
To create a database using Microsoft Access, you need basic computer skills, knowledge of Microsoft Office and specifically, the Access application. You can learn how to create a database using Microsoft Access at the Office section of the official Microsoft website. Once on the page, type "How to create an Access database" into the search field at the top of the page and press enter to bring up the information.
How do you describe Field in a field of Microsoft Access?
rado
How do you describe Hyperlink in a field of Microsoft Access?
rado
Microsoft access the collection of records and field are called?
Tables
Where would the Gettysburg address be stored in a Microsoft access database?
It could be stored in a Memo field, but in reality you would not use Microsoft Access at all to store it. You would store in a Microsoft Word document.
What is the maximum number of characters a text field can store in Microsoft access?
32,767 characters in a standard text field.
In Microsoft Access what does the key symbol mean?
It indicates the field or fields that are the primary key.
What are the columns in Microsoft Access table called?
In a Microsoft Access table each column shows the information in a field. Each row shows a record.
In Microsoft access When a record has an entry that is unique to them such as a customer number this field is called?
unique identifier!!
When using Microsoft Access what is the default field size for a text field?
for 2003? i believe it is 255 characters. not positive though... (I use Access quite a bit, however, I am still not sure of that number)
When you create a blank database the table that Access creates for you contains one field named .?
If you create it in Design View, no field name is given. If you create it in Datasheet View it is called Field1.
