RE: Front End

Dear Halimun

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.


Following is the resopnse I gave to your colleague who had similar query as yourself:


"The topics we covered in Access Intermediate course require the user to have access to the design view of the forms and Reports.

As you may appreciate that a designer has much more control over the structure of the Forms and reports compared to the end user.

The end user is limited to carry out actions set by the permissions set by the administrator/designer.

The answer to your question depends on the permissions granted by the Administrator of the database.

In Advanced level we learn about splitting the database into two (the Front end and back end). The users that have access to the Front end have very limited, if any permissions to modify the design of Tables, Reports and Forms. May be that could be the case in your company which you may want to investigate."

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007