answersLogoWhite

0

Each field is different in a database. A field is a heading for a piece of data. If you were holding data about people the different fields you could have could include:

Firstname, Surname, Date of Birth, Phone Number, Gender, Marital Status etc. None of those are the same. You are not going to have two dates of birth for one person or ask them for it twice, so it will be there once, as will all fields. If you are filling in details for a number of people it is possible that some people would have the same details, like obviously lots of people are going to be male. Each of these relates to one person only, and is known as a record. That is different to a field. We can think of fields as being like columns of data and records as being like rows. In a column, all the data will be one thing, like dates of birth. In each row, there will be one entry for each field and all the data relates to one individual.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How many fields are in the database?

The number of fields in a database can vary widely depending on its design and purpose. Typically, a database table may have anywhere from a few fields to several dozen, depending on the complexity of the data being stored. To determine the exact number of fields in a specific database, one would need to examine its schema or structure directly.


Is 'A database uses characteristics such as field size and data type to define each field' false?

No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.No it is not false. Database fields do have field sizes and data types.


What is a group of fields in a database called?

Any computer based database is composed of certain things in a certain order. The simplest part of a database is the field. Fields can contain pictures or text or sounds or instructions on what to do with other information in other fields. Fields are grouped into Records. Records are the total of all the information on a particular person or item. Records can be combined with other records then to build the database


Why do you require a RegNo field in MS-access when you already have RollNo field?

That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.That question cannot really be answered, as it is down to the data you have and the database you are trying to design. You may well need these fields and have one as a primary key and have another field unique. To properly design a database, a lot of thought has to go into it, especially if there is more than one table and there are relationships. Even for one table you would work out what fields you need and how you design them. So you may have a requirement for both of those fields. It is your design, not Access itself, that decides what fields you need.


When would you use a database program?

when i need to see table relationships and sort data by custom fields


A group of related fields is known as data redundancy?

This statement is incorrect. Data redundancy refers to storing the same piece of data in multiple places, leading to inefficiency and inconsistency. A group of related fields is known as a database or a record in a database.


What is the database that contains tables linked by common fields?

A relational database is a database that contains tables linked by common fields. These common fields are used to establish connections between the tables and to retrieve related data across multiple tables using queries.


A field or a combination of fields that has a unique value is a?

A unique value is a distinct data point that differentiates one record from another in a database. When a field or combination of fields in a database table has a unique value, it means that no other records can have the same value for that particular field or combination of fields, ensuring data integrity and preventing duplication.


Why do you need common fields in a database?

A common field is a field of data that is shared among all forms in a database. Without them, it would be difficult and/or time-consuming to create other forms.


What makes up a database?

A database is made up of related information in Tables and fields.


What is the key fields in a database?

what is a Absolute reference


Describe database normalization?

Database Normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency