our approach
|
new tutorials
|
contact us
Access 2007 In Pictures
Database Basics
Working with Tables
Working with Forms
Working with Queries
Working with Reports
Create a new query in Design View based on the
Artists
table.
Add the
Good Artist?
field to the design grid area.
Add the criterion
False
to the
Good Artist
field.
Change the query type to an Update query.
Update all artists to designate them as Good artists.
TIP:
Set the
Update To
value to
True
.
The query design grid should look like this:
Run the query.
Close the query, saving it as
Make All Artists Good
.
Exit Microsoft Access.
<< BACK
NEXT >>