0
What else can I help you with?
The upper pane of the query window which displays the field lists for tables that are used in the query is the?
table area
What is the difference between update and append query?
Update queries modify information within a record at one or more fields at a time.Append queries copy complete records at a time, adding to the existing set of records in a table.For example, if an "Address" field needs to be changed for the records in a table, you can use an update query to make that change. If you have two tables with various "Customer Information" listings, you can use an append query to copy the records of one table to the other.
Can a query be used to create calculated fields?
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.
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.
What is the SQL UPDATE Query used for?
The SQL UPDATE query is used to update tables when changes have been made or are about to be made It forces the database to be updated and makes sure current information is used for subsequent queries.
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.
The eniac was built to be used during what?
ENIAC was designed and built in WW2 for the following purposes:Calculate new firing tables for existing artillery pieces in use where existing tables were found inadequateCalculate firing tables for new artillery piecesIt had to be able to do this much faster than the existing human computers then used for these tasks. However ENIAC was not operational until after the end of the war.
A database object that retrieves specific data from one of more tables is a what?
A database object that retrieves specific data from one or more tables is called a query. Queries are used to extract information from databases based on specified criteria and are essential for data manipulation and reporting purposes.
What Are words that have a special meaning to Access and cannot be used for the names of fields or tables?
Reserved words!
What word or words have special meaning to Access and can not be used as names of fields or tables?
Reserved Words
What software can be used to create the database tables fields and records?
Database management software
