You can use Microsoft Access’ Simple Query Wizard to quickly
find summary information on two or more joined tables. For example, suppose at
the end of each month you need to create a report summarizing each employee’s
average, minimum, and maximum hours worked per week for the month of June. You
can find the information in two tables, Employees and Hours Worked, which are
joined by Employee ID number.
In order to produce the report in minutes, simply follow
- In the
database window, click Queries under Objects.
the Create query by using the wizard.
Tables/Queries, select Employees, and move Employee ID, First Name, and
Last Name fields from the Available fields column
to the Selected Fields column.
Tables/Queries, select the Hours Worked table and move the Hours and WeekEnding fields from the Available Fields column to
the Selected Fields column.
- Click Next and select Summary.
the Summary Options button, then click the Avg,
Min, and Max check boxes, and click OK.
- Click Next, select Month, and click Finish.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.