Chapter 7. Creating a CheckOut Form

In the previous chapter, you created several forms using the design tools provided by Access. This is what Access does really well, and this is why it is such a popular platform for creating database solutions. It is really easy to create forms for your existing tables. The primary constraint, however, is that the standard forms can only access a single table. There are some ways around this. For example, you can use a query to join related tables and then the form can access all the fields in the query. This is really helpful, especially with a normalized database. You can also use subforms when a parent/child relationship exists between the tables.

As most of us have seen from some painful experiences, there ...

Get Pro Access 2010 Development now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.