How to Get a Date From a Database

Make your queries as user friendly as possible.

Building a new database can be a time-consuming and sometimes complicated process, but once you have that database created, it can be relatively simple to find the data you need. One of the advantages of building a database is that the end users do not have to understand the underlying structure of the database to get the information they need. As the database designer, you can create the queries that allow users to access the results they need to make intelligent and informed decisions.

Instructions

1. Log on to your computer and open your database program. Open the database you want to work with.

2. Click the forms section of the database. Open the database form and use the arrow keys at the bottom to scroll through the records. Each record appears in the form window one at a time as you scroll through the data.

3. Go to the table section of the database window and locate the table whose data you wish to access. Double-click the table to see its data, but be careful not to type any data into the table. Typing data directly into the table updates the database in real time, and you could inadvertently overwrite the existing information if you are not cautious.

4. Click the query section of the database window and use the wizard option to build your query. The wizard option allows you to choose the table you wish to base the query on, as well as the fields you want to display.

5. Choose the fields you want to display in your query, then open the query. You can also right-click the query and choose design view to add a filter for the data. For instance, you can select records whose value is between 1 and 10 by typing "Between 1 and 10" in the criteria section of the query.