0
There is no definitive answer to that, as it depends what you want on the form. Ultimately all data comes from tables. If you just want to show all the records as they are you could base the form on the table. However if you want to display only selected records or certain calculations, you might create a query to do those operations and then base the form on the query.
What else can I help you with?
The table or tables from which a query gets its data is the?
Data Source
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.
Query execution statistics in query processing in dbms?
create table vino(char name(6));
How do you create update query in access?
If its 2007, Go to the "Create" tab, then "Query design" drag all the fields into the table at the bottom, Presto.
Where does the destination table in an Append query show in the query grid?
It does not show in the query grid. On the Append To line you can pick the fields in the destination table that you want values to be appended to. The query grid is just for specifying what fields and records you want to be added to the destination table, so it only needs to show the source table.
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 do you calculate tax using a query in Microsoft access?
The easiest way to do this, assuming you have a fixed tax rate, is to simple create a calculated field in a query.Let's say you have a table with Price, Quantity, and TaxRate in it. Create a query based on that table, and bring these three fields into the query.Now create a new, calculated query in a new column. In the first row (the name) of the query, put the following:SalesTax: (Price * Quantity) * TaxRateWhen you run the query, you should see SalesTaxt as a new, calculated field. Now you can use this query for any forms or reports you need this value in.Hope this helps.Richard Rostwww.AccessLearningZone.com
What information is needed in a query?
In a query, you typically need to specify the data you want to retrieve, the conditions that should be met for the data to be included, and any sorting or grouping instructions. Additionally, you may need to specify the data source or table from which the data should be retrieved.
How do you create a query that will display the top five orders in descending order by order total?
To create a query that will display the top five orders in descending order by order total create a select query object. Open the query design table and select the top five orders, then choose to display them in descending order.
When you create queries in Design view you choose the tables for the query from the?
Show Table dialog box
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).
What is the difference between query datasheet and a table datasheet?
A query datasheet displays the results of a query operation, showing data based on specified criteria or calculations. A table datasheet displays the data in a table format, representing information stored in a database table. In essence, a query datasheet is derived from a table datasheet and is dynamic based on the query criteria.
