access database course - Creating reports

Hi Adeolu, Thank you for your post; It is possible to set user rights to different areas of your database, thus allowing different people access to different areas of your data, this procedure is covered in our Access Advanced course, and is a bit too complex to be described successfully here.
As for protecting data in your report, the data used to populate your report will depend on a table or query, thus protecting the table or query will in turn add protection to the data in the report, (which is only a print preview.) I hope that explains and maybe helps, best regards Pete