Question:What are the different useful tools available in Design Window to help you with your design work? 

The different tools available in Design Window are:
- The Forms Design Toolbar
- The Formatting (Form/Report) Toolbar
- The Toolbox
- The Field List
- The Properties Sheet
- Various Control Wizards

Question:What is a Field List tool available in Design Window? 

The field list is a handy way to reference fields in the Design View Window. To show the field list, click on the field list button on the Design toolbar. You will see a list of fields from the table or query, which is the source of data for the form.

Question:What is the difference between using a filter and a query to find records? 

We can use a Filter to quickly limit the records we are already viewing in a Datasheet or a form to those that match the criteria that we specify. In contrast to this, we can use a Query to view selected fields and records from one or more tables, then save the query to open it later or use it as the basis of a form or a report.

Question:What are the different options that you can use to filter records? 

The various options available to filter records are:
- Filter by Form
- Filter by Selection
- Filter for Input
- Advanced Filter/Sort.

Question:How can you apply Filter For option to filter records based on a value of a field? 

To apply Filter For option to filter based on a value of a field:
- Right click on the field and type the
criteria in Filter For text box of the
context menu

Question:Explain Query. 

Queries are used to retrieve and display specific records in a table. They can also be used to display specific fields of specific records, which meet the condition specified. A query displays a subset of all or specific fields and records in a table. When a change is made to the data, which is displayed by the query, this change is reflected in the table also. Because of this dynamic relationship between the query and the tables, the subset of the data displayed by the query is called a Dynaset.

Question:What is an Auto Report? 

An auto Report is the quickest way to create a report for a table or query. It enerates the report with the table name as the heading and page number as the footer.

Question:Explain Query Parameters. 

If the conditions of the query should be entered at the time of execution of query, we specify the query parameter instead of criteria value or constant. Query parameters are specified inside large braces. Thus, when the query is run, the values of parameters are asked and accordingly the records will be presented.
To set query parameter, type the message inside large brackets in the criteria box of required field. To specify data type of parameter you can select Parameter option from Query menu. In the parameter column, type the message entered in Criteria box then, selects the type of the value that the user has to enter when query is executed in the Data Type column from the drop down list.

Question:For what an append query be used? 

It is easy to append records from one table to another using an append query. There is no need for the tables to have the same number of fields or same field names. However, the two tables must have matching fields and the data for primary key field should be unique and non-empty.

Question:What is a cross tab query wizard? 

A wizard that helps us to present the data in a 2-dimensional tabular format is the crosstab query wizard. You can use this to create queries that will depict the data in particular fashion, i.e. item wise sales made or customer wise sales made etc.