Determining The Forms You'll NeedAs explained on the Access Database page, forms are data-entry tools, another one of Access tips.
You can arrange fields from several tables on a form and easily enter data into those fields on a single screen.
For instance, a customer order form might include information from the Orders table and the Products table.
When thinking about what forms you'll need, the question is really about what actions you would want to perform.
The following list describes some actions that might require a form:
It's usually printed (unlike tables and forms, which are usually used on-screen).
For example, you might want a report of all the people who haven't paid their memberships or accounts due, with a balance more than $1,000.00
A report is usually for the benefit of a person who doesn't have access to your computer's database.
For example, you might print a report to hand out to the board of directors to encourage them to keep you on as CEO.
You are allowed to extract data from different tables to use in one Report, perform calculations on the data (such as sum or averages).
It is presented to you with a neatly formatted end result.
The following are some things you can do with reports:
You can create new reports at any time: you don't have to plan them before you create your database. However, if you know you need a certain report, you might design your tables in the format that will be most effective for that report's use.
Access XP Topics- Screen layout
- Storing data
- Database planning
- Tips for tables
- Tips for forms
- Tips for reports