Microsoft Office Tutorials and References
In Depth Information
CREATING QUERIES
FIGURE B-42
Updating the wage rate for nonsalaried workers
Now run the query by clicking the Run button in the Results group. If you cannot run the query because
it is blocked by Disabled Mode, click the Database Tools tab, then click Message Bar in the Show/Hide group.
Click the Options button, choose
enable this content,
and then click OK. When you successfully run the
query, the warning message in Figure B-43 appears.
FIGURE B-43
Update query warning
When you click Yes, the records are updated. Check the updated records by viewing the Wage Data table.
Each nonsalaried wage rate should be increased by $0.50. You could add or subtract data from another table
as well. If you do, remember to put the field name in square brackets.
Another type of query is the Delete query, which works like Update queries. For example, assume that
your company has been purchased by the state of Delaware, which has a policy of employing only state
residents. Thus, you must delete (or fire) all employees who are not exclusively Delaware residents. To do that,
you would create a Select query. Using the Employee table, you would click the Delete icon in the Query
Type group, then bring down the State field and filter only those records that were not in Delaware (DE). Do
not perform the operation, but note that if you did, the setup would look like the one in Figure B-44.
 
Search JabSto ::




Custom Search