Microsoft Office Tutorials and References
In Depth Information
Querying a Database
A dialog box appears, asking you to identify the fields you want to
display from the database table you chose in Step 4.
8. Click a field and then click the > button. Repeat this step for each
additional field you want to display.
9. Click Next.
A dialog box appears, asking you to give your query a descriptive name.
10. Type a descriptive name in the text box and then click Finish.
Access displays your query results, which show you only the data in
fields you selected in Step 8.
11. Click the File tab and choose Save to save your query.
Viewing, renaming, closing,
and deleting queries
Each time you create and save a query, Access stores it for future use. After
you create and save a query, you can add or delete data from your tables and
then apply your queries on the newly modified data.
To view a query, just double-click on the query name in the left pane. In case
you need to rename your query to give it a better descriptive name, follow
these steps:
1. Right-click on the query name in the left pane.
A pull-down menu appears.
2. Choose Rename.
Access highlights the query name.
3. Type a new name and then press Enter.
Each time you view a query, it displays a tab. Eventually, you’ll probably
want to get rid of a query, so to close a query, follow these steps:
1. Right-click on the query name that appears in the tab.
A pull-down menu appears.
2. Choose Close.
Access closes your chosen query and removes its tab from view.
 
Search JabSto ::




Custom Search