1 / 6

Activity 1 Creating a simple query in the Design View

Activity 1 Creating a simple query in the Design View. In this activity, we are going to create queries in the Design View which will extract records from the tables ‘CPU’. Copy the database file ch11_01.mdb from the Learning CD-ROM to the hard disk.

kyra-franco
Download Presentation

Activity 1 Creating a simple query in the Design View

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Activity 1 Creating a simple query in the Design View In this activity, we are going to create queries in the Design View which will extract records from the tables ‘CPU’. • Copy the database file ch11_01.mdb from the Learning CD-ROM to the hard disk. • Start Microsoft Access and open the database file ch11_01.mdb. • Click ‘Queries’ in the ‘Objects’ column and then click . New

  2. Double-click ‘Design View’ in the ‘New Query’ dialogue box. Double-click ‘CPU’ in the ‘Show Table’ dialogue box to add the table into the Design View window. Then, click to continue. Activity 1 Creating a simple query in the Design View Close

  3. Click from the pull down menu in the row ‘Field’ of the first column. Then, select the field ‘Brand’ to add the field to the Design View window. Add two more fields ‘Product’ and‘Socket’ to the Design View window. Activity 1 Creating a simple query in the Design View

  4. Enter ‘LGA771’ into the criteria box of the ‘Socket’ field. Select ‘Queries’  ‘Run’ to execute the query. Alternatively, click the ‘Run’ button on the toolbar. The query result will be displayed in the Datasheet View. Activity 1 Creating a simple query in the Design View

  5. Select ‘File’  ‘Save’ to save the query. Enter the query name ‘LGA771 Query’ in the ‘Save As’ dialogue box and then click . Close the query and the database file. Then, exit Microsoft Access. Activity 1 Creating a simple query in the Design View OK

  6. Select ‘File’  ‘Save’ to save the query. Enter the query name ‘LGA771 Query’ in the ‘Save As’ dialogue box and then click . Close the query and the database file. Then, exit Microsoft Access. Activity 1 Creating a simple query in the Design View OK

More Related