answersLogoWhite

0

A database stores information like names, address, dates of birth etc. When the database is being designed, headings for these things are create, to store the different parts. These are the fields. "Name" is a field, and it could have the fieldname "Name". The designer will often decide to break the name into a first name and a surname. In that case each field would need a different fieldname. They might use "Fname" and "Sname" for example. "DOB" is often used as the fieldname for the field to store Dates of Birth. When the designers are then working to do queries or other programming with the database, they will use the fieldnames to access the data.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

How do you get an average on a database?

SELECT AVG(FieldName) as "FieldName_Avg" FROM TableName


Sql code for palindrome checking in sql?

FieldName = REVERSE(FieldName) FieldName = REVERSE(FieldName)


Which operator is used to indirectly access a member of a struct?

pointer -> fieldname


What are Joins in dbms?

A join is a temporary relationship that you can create between two tables in a database query that do not already have an established relationship or common field with the same fieldname or data type. Database tables that are joined in a query are related in that query only, and nowhere else. The type of join that you use indicates which records the query will select or perform the chosen actions on.


How to link my dates in my Microsoft access table to the clock on my computer to produce an up to date difference in the date in my table?

the function to calculate the current date and time is "now()". to query the time you can type "<now()" or ">now()". to calaulate the difference, "now()-fieldname" to insert the current ate and time into a record set the vb code "fieldname = now()" to the after_insert event hope that helps


What kind of application in MS Access?

It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.


Enter on the database or in the database?

We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.


What is a derived database?

We know what is database, it is a collection records. When a database is created from the existing database it is known as derived database.


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


What is the range of database application?

The range of database application are given below: 1- Personal Database 2- Workgroup Database 3- Department Database 4- Enterprise Database


What is active database and cloud database?

The database we use in our daily life is called as active database . The data that is stored in the database which is further stored on the cloud is called cloud database.


How is a database structured?

database structure depends on the business requirement and size of database. database structure depends on the business requirement and size of database.