microsoft access training course - 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