Extend Microsoft Access Applications with the guidance of Andrew Couch

This is your complete, practical guide to creating Microsoft Access web apps and migrating existing databases to the cloud.

In this eBook Andrew Couch will show you how to take advantage of using queries in your web app, including working with calculations and parameters.

This chapter will cover

• Creating basic queries
• Adding criteria to queries
• Adding calculations to queries
• Adding parameters to queries
• Totals and queries
• TOP value queries
• Unique values in queries

About the author: Andrew Couch, MVP, UK

As a founding member of UK Access User Group, I have worked as magazine editor, guest speaker, trainer and website manager for this group and also UK Office User Group. From starting my career writing assembly code working with popular programming languages I have continued programming for over 15 years and have seasoned experience with many varieties of databases and client-server developments.

I work with a number of partner organisations to undertake work within diverse industries from some of the world’s large financial institutions to manufacturing companies and start up businesses. As a developer my favourite back-end development tool is SQL Server, and favourite front-end tool is Access, however occasionally I find that .Net is a better solution for my clients.

My key expertise is in migrating large Access databases from Access back-ends to SQL Server. Over the past 10 years myself and clients have been using my own migration tool, which is now packaged as a commercial product at http://www.upsizing.co.uk. This product is in use by over 150 companies worldwide and is a leading solution in self-contained accurate query translation tools.

Having spent a lot of time writing white-papers and sharing expertise with communities I have recently focused on working with Microsoft Press to publish technical resources. I am author of, Access 2010 VBA Programming Inside/Out and have acted as Technical Reviewer for Microsoft Press on Access 2010 Inside/Out.