Divya has attended:
Access Intermediate course
Forms and report
When should I use a form and when should I use a report?
RE: Forms and report
Hello Divya
Formas and reports have different functions, and you would choose to use each one to fulfil a specific outcome.
A form is used to ENTER, EDIT and VIEW records individually. A form is laid out in a logical, easy to read format, much like a paper form. The benefit of uising a form, is that you can design it to match a paper form if you are doing data capture.
You can enter data into multiple tables under the form, without even knowing it. Non-technical users can use a database easily using forms, without having to get involved in the queries and tables underneath.
Reports are used when you want to display the information in specific tables or queries in a logical PRINTED format. Again, you can map the fields in the report to match your desired look and feel, and you can format the fields in any way you choose, bold, italic, underlined, colours, boxes, graphics, etc. You can give your report a branding by using a logo and colours assosciated with the organisation that is using the database.
Reports allow you to see multiple records simultaneously, whereas Forms are record by record.
Regards
Richard
Microsoft Office Specialist
