Chat with AI
New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Edition 1ISBN: 978-1285099200New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Edition 1ISBN: 978-1285099200 Exercise 1
is a single characteristic of a person, place, object, event, or idea.
Explanation
Verified
Verified
Field is a single characteristic of a person, place, object, event, or idea. Database table can contain more than one field with different names. Other name for fields is column or attributes. Consider a student table with the fields such as student name, student address, student phone number, grade, marks. It gives complete details about students in a class. Here student's address is a characteristic of a place.
• Collection of fields is called a record. Field is the part of record.
• In every table, a particular field will be a primary key.
• Every field belongs to certain data type such as text, auto number, date/time, number, currency and many other data types.
• Field is an integral part of a table.
• Field data can be duplicated to more than one record in the table except the primary key field's data.
• There are some possible actions can be done in table field such as adding, deleting fields, reordering fields, editing field values whenever needed.
• Using field one table can be linked to another table. There forms a relationship between the tables.
• Field name should be meaningful to describe the characteristics of the field. For each and every field you can define some properties such as caption, default value, length, index, format, text alignment and many other properties.
• Collection of fields is called a record. Field is the part of record.
• In every table, a particular field will be a primary key.
• Every field belongs to certain data type such as text, auto number, date/time, number, currency and many other data types.
• Field is an integral part of a table.
• Field data can be duplicated to more than one record in the table except the primary key field's data.
• There are some possible actions can be done in table field such as adding, deleting fields, reordering fields, editing field values whenever needed.
• Using field one table can be linked to another table. There forms a relationship between the tables.
• Field name should be meaningful to describe the characteristics of the field. For each and every field you can define some properties such as caption, default value, length, index, format, text alignment and many other properties.
New Perspectives on Microsoft Access 2013 1st Edition by Joseph Adamski,Kathy Finnegan,Sharon Scollard
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
