ACCESS 2007 WORKBOOK FOR DUMMIES

The book will guide the users through creating the Media Database while teaching how to build tables and relationships, use select and action queries, build forms and reports, and automate with macros. The Media Database contains data pertaining to a home media collection (CDs, DVDs, Books, etc.). Using the Media Database allows a wide variety of readers to identify with the concept of a database without teaching them business fundamentals such as accounting, inventory, etc.

The reader will create tables to store different types of media as well as supporting tables required to fill dropdown lists, demonstrating relationships. They'll create queries to retrieve certain types of media and action queries to add, edit, and remove data. They'll build a user interface to add, edit, and update data and create a full application to track every aspect of their media collection. They will also track the costs of their collection with a tie in to buying and selling items on EBay. This allows the reader to create forms and reports with totals and calculated fields. The readers will also tie everything together by automating the navigation of the application through macros.

The CD included with the book would contain before and after example files for each exercise, as well as a full working application to track their media collection. Select exercises would also include video walkthroughs that demonstrates the precise steps required to perform the tasks. The combination of the sample database and video walkthroughs allow the reader a few different methods of learning Access.

Idioma: INGLÉS