Throughout this course you will have the opportunity to work on the course project. The course project is a database you will build yourself.
We will help you out a little, you will not have to enter all the data (since you did that in
Building a Database), but you will create queries, forms and reports. The course project is based on this scenario:
- You are a technical writer doing contract writing for the marketing and documentation departments of companies in the software and networking business. You have two large clients named Network Consultants, Inc., a network consulting company, and Dynamic Solutions, a startup software development company currently building a word processing application.
- You are juggling many projects and you find that you need to keep better track of your clients and the projects you do for them. After some research, you decide that the best way to address this problem is by building an Access database. In addition to tracking the work you do, the Access database will enable you to do analysis. For instance, you will be able to create a list of the work done in the last month. You will also be able to create a query and a report to invoice your customers.
Problem:
I need to construct a query that takes a criterion, but the criterion's value will not be known until the query is run. When it is time to run the query, the user needs a way to supply the criterion without going into the design of the query.
Solution: A query can be designed to accept parameters at the time it is run. Typically, an input box will appear in which the user enters the value for the criterion. A query can have any number of criteria entered in this fashion. A set of brackets defines the question asked in the input box. The brackets and the prompt to the user are placed in the Criteria row of the query grid for the given field. For example, using
[Enter an age]
as the criterion for a field instructs Access to present this prompt in a dialog box,
Discussion:
When a query is run, a traditional form is often displayed to enable users to enter parameter values or make selections from a list.
But the ability to place parameters directly in the structure of a query provides a great alternative to having to build a form that gathers input. When the criteria are simple, just using brackets in the query design will suffice. When the query is run, the dialog will appear, and the returned records will be filtered to those that match the entered value.