FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Click the Create tab on the ribbon. Click the Query Design button. You can also use the Query Wizard to create a query. Click the Create tab on the ribbon and click the Query Wizard button in the Queries group.

Detailed explanation-2: -On the Create tab, in the Queries group, click Query Wizard. In the New Query dialog box, click Simple Query Wizard, and then click OK. Next, you add fields. You can add up to 255 fields from as many as 32 tables or queries.

Detailed explanation-3: -Open the database that contains the records you want to update. 1. On the Design tab, in the Macros & Code group, click Query Design.

Detailed explanation-4: -Method D: Under the Home tab, click the Design View button in View group, then the Access will be displayed in Design View. Method E: Get into Design View with right-clicking the table name in the left window and selecting Design View from the popup menu.