Querying a Database - Microsoft Office - Lecture Slides, Slides of MS Microsoft Office skills

Here are some tutorials on MS office. Explaining excel and other features. This tutorial includes: Querying a Database, Opening the Database, Including Fields in the Design Grid, Query Window, Clearing the Design Grid, Using a Wildcard, Saving a Query, Number in a Criterion, Using a Compound Criterion, Sorting Data in a Query, Joining Tables, Calculating Statistics

Typology: Slides

2013/2014

Uploaded on 01/29/2014

jamil
jamil 🇮🇳

4

(12)

139 documents

1 / 73

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Access Project 2
Querying a Database Using
the Select Query Window
docsity.com
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49

Partial preview of the text

Download Querying a Database - Microsoft Office - Lecture Slides and more Slides MS Microsoft Office skills in PDF only on Docsity!

Access Project 2

Querying a Database Using

the Select Query Window

Objectives

  • Create and run queries
  • Print query results
  • Include fields in the design grid
  • Use text and numeric data in criteria

Objectives

  • Join tables in queries
  • Perform calculations in queries
  • Use grouping in queries
  • Create crosstab queries

Opening the Database

  • Click the Start button on the Windows taskbar, point to All Programs on the Start menu, point to Microsoft Office on the All Programs submenu, and then click Microsoft Office Access 2003 on the Microsoft Office submenu
  • If the Access window is not maximized, double- click its title bar to maximize it
  • If the Language bar appears, right-click it and then click Close the Language bar on the shortcut menu

Creating a Query

  • Be sure the Ashton James College database is open, the Tables object is selected, and the Client table is selected
  • Click the New Object button arrow on the Database toolbar
  • Click Query
  • With Design View selected, click the OK button
  • Maximize the Query1 : Select Query window by double-clicking its title bar, and then drag the line separating the two panes to the approximate position shown on the next slide

Creating a Query

  • Drag the lower edge of the field box down far enough so all fields in the Client table are displayed

Including Fields in the Design Grid

Running a Query

  • Click the Run button on the Query Design

toolbar

Closing a Query

  • Click the Close Window button for the Query1 : Select Query window
  • Click the No button in the Microsoft Office Access dialog box

Including All Fields in a Query

  • Be sure you have a maximized Query1 : Select Query window with resized upper and lower panes, an expanded field list for the Client table in the upper pane, and an empty design grid in the lower pane
  • Double-click the asterisk at the top of the field list
  • Click the Run button
  • Click the View button on the Query Datasheet toolbar to return to the Query1 : Select Query window

Clearing the Design Grid

  • Click Edit on the menu bar
  • Click Clear Grid

Using Text Data in a Criterion

  • One by one, double-click the Client Number,

Name, Amount Paid, and Current Due fields to

add them to the query

  • Click the Criteria row for the Client Number

field and then type CP27 as the criterion

  • Click the Run button to run the query

Using a Wildcard

  • Click the View button on the Query Datasheet toolbar to return to the Query1 : Select Query window
  • If necessary, click the Criteria row below the Client Number field
  • Use the DELETE or BACKSPACE key as necessary to delete the current entry (CP27)
  • Click the Criteria row below the Name field
  • Type Fa* as the criterion

Using a Wildcard

  • Click the Run button to run the query
  • If instructed to do so, print the results by clicking the Print button on the Query Datasheet toolbar