0
Why is having a first and last name field in Microsoft Access better?
Wiki User
∙ 9y ago
It is always better to have them as separate fields. It is very common to sort on last names and if there was a field which held the first name and last name in one field instead of two separate fields, it would not be possible to do that. If you take a phone book, the entries are always sorted by the last name. So in a properly designed database the first name and last name should always be separate fields.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How do you describe Field in a field of Microsoft Access?
rado
How do you describe Hyperlink in a field of Microsoft Access?
rado
In Microsoft Access what is an attribute?
An attribute would refer to a field in the tables that you create in Access.
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!!
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.
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)
In Microsoft Access if the value 1000.5 is entered in a field in access that has been defined as currency data type then the value will display how?
$1,000.50 (depending on how you configure comma and currency symbol)
