• Home
• Microsoft Access Tutorial
• MS Access Forms
• MS Access Forms Design Examples

 

MS Access Forms Design Examples

Yes, Microsoft Access is where you can hope to make great database from. Within your database, you will have to work on all sorts of things though, like the tables, macros, forms, etc. Speaking about forms, there are various design examples people can use. However, no matter what design you choose, you have to know basic MS Access forms design examples first to better understanding about forms. Let’s see ones from Access 2013 here. There are 4 of them that you can learn here.

 

Single Table Form Design in Microsoft Access 2013

 

You can say that this form design is the most basic of all. As the name suggests, the design will have a single form corresponding to only a single database table. It is simple design, indeed. There won’t be single form resulting from 2 or more tables. If you want to make such form though, it is not impossible in Microsoft Access 2013. However, this is just not the right form design for such thing.

 

Single Table Form with Lookup Field in Access 2013

 

The second table form design of MS Access here actually looks pretty similar with the first one above. You have single form resulting from only single database table. However, what’s different in this design is that you can have one or even more fields with data from other tables. You may also have this extra data in the design to hold other things, like summary results or calculated values as well.

 

Master/Detail Form Design in Microsoft Access 2013

 

You have more complex design this time. Now, you will have 2 kinds of form in one design. The first form is just like Single Table Form earlier and is called here as master form. However, this design will also include another form called subform where you will get the form showing one-to-many relationship. Master/Detail Form is pretty much detail in its design, just like how the name suggests.

 

Master/Detail Form with Lookup Fields in Access 2013

 

This is the last MS Access 2013 basic form design you need to know. As you might have guessed, this design is basically not that much different from the Master/Detail above. However, it has lookup fields just like the second form design earlier. So, there is extra data holding other tables, results, etc. that correspond to a single form. Master/Detail blocks are where lookup fields are designed to be.

 

There you go. They are all the basic form designs in Microsoft Access 2013. They might be similar to each other. However, each design is truly meant to be different than the others. So, you can choose which design that would suit your needs the most when making database with Access 2013. By looking at the MS Access forms design examples above, you should get enough understanding about the Access forms, right? Form really is an important basic Access component in database after all. It acts as the window into the schema of your database.