Provides information on the features and functions of Microsoft Access, covering such topics as normalizing and storing Excel data in a structured relational database, using Excel pivot tables with Access data, using Access to analyze large amounts of data, and getting external data with SQL, ADO, and XML.
Michael Alexander is a Microsoft MVP and a veteran consultant. He creates and shares video tutorials with the Microsoft Excel and Access communities via www.datapigtechnologies.com. Mike has written several books on advanced business analysis, including Microsoft Access 2007 Data Analysis, also from Wiley.