create a table containing the number 1 to 10 use this table to create a query that reads from the table and computes the value of number x Five for each number.
please help me give me the long answer for this question(please don't spam)
Answers
Answer:
The process of creating a make table query follows these broad steps:
Enable the database, if it is not signed or if it does not reside in a trusted location. You cannot run action queries (append, update, and make table queries) otherwise.
In query Design view, create a select query and then modify that query until it returns the records you want. You can select data from more than one table and, in a real sense, you can de-normalize your data. For example, you can place customer, shipper, and supplier data in a single table, something you would not do in a production database with properly normalized tables. You can also use criteria in the query to further customize or narrow your result set.
For more information about normalizing your data, see the article Database design basics.
Convert the select query to a make table query, choose a location for the new table, and then run the query to create the table.
Do not confuse a make table query with an update or append query. You use an update query when you need to add or change data in individual fields. You use an append query when you need to add records (rows) to an existing set of records in an existing table.