0
It is a query inside another query. Normally it is a select statement inside a query. Sometimes you want to run query and use data from another query in that query. So you will have one query inside another one. The inside or nested query is the subquery.
Wiki User
∙ 10y ago
Wiki User
∙ 10y agoIt is a form inside another form. It is often used where tables are related, particularly in one to many relationships. So you could have a main form which shows the details of a class in a college and a subform which shows details of the people who are taking that class. When you view a different class, the list of students will automatically change too. The class would be from one table and the students from another, with the two tables being related to each other. The two forms can be created separately and then one put into the other. The sub form can also be viewed on its own.
Add your answer:
Earn +20 pts
What are the uses of a Query?
In MS Access, a Query is a saved search, which can be used in reports, etc.
Which query language will use in MS Access to maintain database?
It uses a version of SQL. (Structured Query Language).
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.
Can write query within the query?
Yes, you can have a query inside a query. That is known as a sub-query.
How do you find maximum and minimum of 5 number in ms access?
You can use the Max function and the Min function in a query to do it. They are both available when you use the Totals row in the query design grid.
A query that that retrieves records based on the results of another query is referred to as a?
This is called a correlated sub-query.
What are the disadvantages of Microsoft PowerPoint to Microsoft Access?
SQL - Structure Query Language for MS Access is not as robust as you get on some other RBMS like MS SQL Server, Oracle etc. SQL gives you the flexibility of of data definition and manipulation using script. Pelumi (Nigeria)
What is a complex query in Microsoft access?
A select query with multiple criteria
What do you click to create a query on the query wizard on the ribbon in access?
create tab
Do you have to have a query in access before you can have a form?
no
How do you install MS Query?
Re-run MS Office setup from CD choose to modify setup. Check "options" checkbox to explore components and in MS Office Tools, I believe, sellect MS Query to be installed. Make sure not to uncheck existing components
What is a Brio Query File used for?
A brio query file - file extension bqy - is typically an sql query that can be connected to a RDBMS and return an answer or result set. A brio query file is created using Brio explorer or designer software. This sofware creates SQL queries using a graphic interface to render database objects that can be dragged and dropped on to the designer space. Query design is similar to MS Access.
