Depending on the version of Access you have, this method might be different. This solution can work for all Microsoft Access versions.

Microsoft Access is a database management system program that combines the relational Access Database Engine with a graphical user interface and software development tools. In Microsoft Access, you ...