Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Let’s revisit a popular aspect to your Microsoft Access database design; Creating a many-to-many relationship.

Firstly, watch this quick video which explain the key components and the starting steps to getting to the many-to-many state for your Access database.

httpvh://www.youtube.com/watch?v=7XstSSyG8fw

In order to create this type of relationship, it’s now clear we need an interceding or junction table to handle the two-way joins of the outer tables with Continue reading “Microsoft Access Tutorial: Creating A Many-To-Many Relationship”

Microsoft Access Database Tutorial: Creating a Menu Form

Microsoft Access Database Tutorial: Creating a Menu Form

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database.

Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms.

httpvh://www.youtube.com/watch?v=bqs8LIgKZTA

Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons Continue reading “Microsoft Access Database Tutorial: Creating a Menu Form”