Advanced Databases

The goal of any successful business is that many customers return many times and buy many things.

 

So, our Mighty Access database has to represent a many-to-many relationship and document that information in reports. In the Front Row Video business model the customer walks out with many movies and a receipt. 

 

The goal of the Advanced Access programming is to create the Forms and Reports for the customer receipt. This book begins with an important discussion on Tables and Table Relationships. Then, the Advanced Form and Report lessons create the data entry and the Point of Sale (POS) receipt. The last discussions includes strategies for archiving and database administration.

 

This lesson offers a summary of the goals and objectives for the advanced programming in this Guide.

The Computer  Mama Sez: "Advanced" doesn't mean hard. Advanced means this database finally has enough programming to get the work done!

 

Screenshot of the completed Receipt