answersLogoWhite

0

If its 2007, Go to the "Create" tab, then "Query design" drag all the fields into the table at the bottom, Presto.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What do you click to create a query on the query wizard on the ribbon in access?

create tab


What you can use inbuilt feature in MS Access to create tables?

You can use the Create Table Wizard, a Make Table Query or a Data Definition Query as ways that are built into Access to create tables.


What kind of query can change the contents of a table A selection query cannot?

There are several types that can do it. A Delete Query, an Update Query and an Append Query can. You can also create and delete entire tables with queries.


How to change a field to Uppercase in a query?

Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.


Which tool do you use to create a query object in access?

database


What is a query that changes data called?

An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.


What is the use of execute non query in c?

It is not C, it's SQL. Non-query means DML (INSERT, UPDATE, DELETE) and DDL (eg CREATE TABLE).


Why create view in database?

A View is similar to a Table and can be mistaken for a table by a novice application developer. CREATE VIEW VIEW_NAME AS SQL QUERY Here the SQL Query includes the Select query on a table that is to be displayed as a View. The view is a read only structure that only displays contents from a table and the user cannot insert or update or delete any data in the underlying table. Views are generally created to impose access restrictions to a specific subset of users whom you do not want to give full access but at the same time want them to view the data.


What is a query a statement requesting for?

update of information


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.


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.


What is a complex query in Microsoft access?

A select query with multiple criteria