1 - Click the Create tab.
2 - Click the Query Wizard button.
3 - Click Simple Query Wizard.
4 - Click the OK button.
5 - Select a table or existing query.
6 - Select the fields required to be included in the query.
7 - Click the Next button to continue.
8 - Type the name of the query.
9 - Choose an option to view the results of the query in the D
10 - Click the Finish button.
Explanation:
1.Click the Create tab and then click the Query Wizard button.

2.Click Simple Query Wizard, and then click the OK button.

3.Select a table or existing query.
4.Select the fields required to be included in the query.
5.Click the Next button to continue.

6.Type the name of the query.
7.Choose an option to view the results of the query or modify the design of the query in the Design view.
8.Click the Finish button.

A parameter query prompts a user for information to be used in the query. For example, a range of dates. This type of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times.
Answer D is incorrect. A select query is a simple type of query that is commonly used in Microsoft Office Access 2007. This query retrieves data from one or more tables and displays the results in a datasheet. A user can use a select query to group records and calculate sum, counts, averages, and other types of totals. The user can also work with the results of a select query in the Datasheet view to update records in one or more related tables at the same time.
Answer A is incorrect. An action query is used to update multiple records in one operation. It is a form of select query that performs an action on the results of the selection process. There are four types of action queries available in Microsoft Office Access 2007, which are as follows:
1.Delete queries: A delete query allows to delete records from one or more tables.
2.Update queries: An update query allows to modify fields. This is used to update a field with an expression or data from another table.
3.Append queries: An append query allows to add records from one or more tables to the end of one or more other tables.
4.Make-table queries: A make-table query allows to create a new table from all or part of the data in one or more tables.
Answer C is incorrect. A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix.

The various benefits of specifying a primary key for a table are as follows:
MS Access improves the database performance by automatically generating an index for the primary key.
MS Access ensures that each record consists of a value in the primary key field.
MS Access ensures that each value in the primary key field is unique.
Answer A is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table.

In order to accomplish the task, you should choose the Design tab lying in Form Layout Tools. You can add new elements, change the header/footer, and apply themes to the form by using the Design tab.

Answer D is incorrect. The Arrange tab has various layout options.
Answer A is incorrect. The Format tab is used to change the color and font of text and the style of gridlines around the fields. It also includes a logo and various formatting options.
Answer C is incorrect. This tab is not displayed in Form Layout Tools.

A Microsoft Office Excel worksheet is the best place to perform the following tasks to manipulate data before importing it into Access:
Add or remove fields.
Combine or split fields.
Use complex mathematical functions.
You can easily import a worksheet or a named range from a worksheet into a new table or an existing table. You can also import some particular fields from a worksheet or a named range into Access.
Answer A, D, and B are incorrect. You can use these three places for importing data into Access, but all these have a complicated process of importing information.