no
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.
create tab
by using the query wizard or design view
DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).DDL stands for Database Definition Language. It is a language used to create a database. Most databases have a language that will do this. Normally it is a form of SQL (Structured Query Language).
create a from with an unbound text box. call this box "search". call the form "search" also create a query on the table you wish to search and modify the querys design. under the field(s) you what to search type forms![search]![search] create a form on this query from the "search" form create a search button that opens the search result form. you could also put this procedure on the after update event on the search box
Go to the options bar and click add. then type in your query. it is pretty simple!
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.
If its 2007, Go to the "Create" tab, then "Query design" drag all the fields into the table at the bottom, Presto.
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.
create table vino(char name(6));
i dont know The term 'query' means to search, to question, or to find