Assignment: SAM Exam Access Module $03$ Crea...

Task: AC$12596$ Use SQL View to create a query with criterio...

le Task

Attempts Remaining

$9$

Submit

onstruction Workshops.accdb $-$ Access

Query Tools

Sign in

External Data

Database Tools

Design

Tell me what you want to do

Union

Insert Rows

L$$ Insert Columns

Delete Rows

$$ Delete Columns

pend

Update Crosstab

Pass$-$Through

Ane Insert

Add

Tables

${\displaystyle \underset{?}{\overset{?}{}}}E[?]$

$$Return:

Totals Parameters

Property $5$

ing

Table Nant

Query Type

Data Definition

Query Setup

Show$/$Hide

AprilWorkshops

SELECT $*$

FROM Workshops:

Task Instructions

In SQL view, modify the SQL code to select only those records where the WorkshopDate field value is before $5/1/21.$