0
Yes. Queries are often used to do calculations and can then produce a field. However anything that can be calculated from other fields should not go into a database table, which is why we use queries to get them. The queries just display them but do not add them into tables. There is no need to do so. From the perspective of users, they will see calculated data appearing on a form or in a query or in a report, as if the data was a field in a table.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What programs can be used to create a database?
query language
Can AND criteria determine fields selected for a query?
Criteria determine what records can be shown, not what fields can be shown, so the AND criteria cannot be used to determine what fields to select.
What is the data language used to create a database and describe all the items in the database?
SQL (Structured Query Language) is commonly used to create and interact with databases. It is a specialized language for managing and manipulating data stored in relational database management systems. With SQL, you can define the structure of a database, create tables, insert, update, and query data stored in those tables.
Can you use query language to extrapolate information from a database?
Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.Yes. That is one of the things that a query is used for.
Which tool is used to create a query object?
a computer, a keyboard, oh and you might need a brain too
What is DDL in databases?
DDL stands for Data Definition Language, which is a set of commands used to define, alter, and drop database objects like tables, indexes, and views. DDL statements include commands like CREATE, ALTER, and DROP, and they are used to design the structure of the database and its schema.
What is a query used for on a database?
A query is used to retrieve specific information or data from a database based on specific criteria. It allows users to search, filter, and retrieve data that meets their requirements. Queries can also be used to update or modify existing data in the database.
Is AutoCAD used in engineering?
Yes, AutoCAD is used in many engineering fields to create drawings and plans.
Does a form offer a quick and easy way to retrieve specific fields or records from a table?
A form can do the presentation of the records, but it is usually a query that does the actual work of retrieving the data. A form can be attached to a query, so as a user sees it, the form is doing the work. So if everything is designed properly, a form can be used to retrieve specific records or fields.
Query used to add fields to existing tables?
The query can be called an Append query. New columns can be added to existing tables by using the ALTER TABLE command in SQL. ex: ALTER TABLE tbl_employee ADD emp_address VARCHAR(100); The above command adds a column emp_address to an existing table tbl_employee
If the copy case command is used to create a new case for a patient what fields almost always must be changed?
[LO 5.2] If the Copy Case command is used to create a new case for a patient, what fields almost always must be changed?
What software can be used to create the database tables fields and records?
Database management software
