Current location - Health Preservation Learning Network - Fitness coach - Left side fitness
Left side fitness
1. First, open the ACCESS database file, and then click Create Ribbon Query, as shown in the following figure.

2. Click Query Design to open Query Designer.

3. Double-click the tables "tTeacher" and "tCourse" in the Show Table dialog box to close the Show Table dialog box.

4. Double-click the teacher's name, professional title and college in the tTeacher table, and double-click the course ID, course name and class date fields in the tCourse table.

5. In the seventh list of field lines, reach the expression "format" ([class date], "m"), enter the condition value 3 in the corresponding condition line, and end.