Microsoft Access has a lot of features, but many fail to take advantage of it because the program seems so difficult to use. But these tips will help you learn how to use Microsoft Access and be more productive. Many of the features in Access can be learned more easily by using its Query Wizard, so you should use it.
Query a Database
Launch Access and open the database that you will query.
In Access 2007, click “Query Wizard” from the Create tab. Choose “Simple Query Wizard” and the Wizard will appear.
In the “Tables/Queries” drop-down list choose the table that you want to query. Go to the “Available Fields” list and double click the items that you want added to the query. Click next when all the items have been added.
Select between a summary or detail query. If you chose Summary, select the “Summary Option” button for customization options. Click Next.
Type a title for your query and click Finish.
Create a Date Query
Start Access and open your database.
Choose “Query Design” from the “Create” tab. The Show Table Dialog box will show up. At the Show Table dialog box, click a table. Close the Show Table dialog box.
Double click the field names at the table field. At the “Criteria” field of the date field, add a date. Suppose you are looking for files processed on July 1, 2012; input the date as “#7/1/12#.” Do not forget to include the # symbol.
Click the Run icon to run your query.
Create a Free Form Query
Open Access and your database.
Choose “Query Design” from the “Create” tab. When the Show Table dialog box shows up, select the table and add. Close the Show Table dialog box.
To learn how to use Microsoft Access to make free form queries, double click the fields. Once the fields fill up the query window, add criteria to the “Criteria” field to refine your query. If you are searching for invoices over $600, use the following: “>600.”
Click the save icon when you are finished. Click OK after you have given it a name.
Click the Run button to process your query.
Launch Access 2010 and open your database.
Select “Query Design” from the Create tab.
Click the Add button and put tables in the database. Close the Show Table dialog box.
To include fields, click the name of the field and drag it to the query. Add a field for time. Click the field and “Property Sheet” button to make sure the field is formatted for time. The Format field should specify time.
Now you can start adding criteria to the time field. If you want to check invoices processed after 9:00 am, apply the following criteria: “>#9:00:00 AM#”. The “>” signifies items following the time.
Click the Run button.
Now that you know how to use Microsoft Access, you will have an easier time preparing tables, reports and perform other tasks. Note that the tips given above work for different versions of the program. The only difference is that the location of some of the icons may have changed.
Nick is a free lancer writer of http://www.mightyguide.net/