Investigates several key database-programming concepts and how to combine them to create a high-quality database with Microsoft SQL Server.
Explores the functions, commands, and techniques in Excel that quickly restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis.
Spells out the design considerations and tools needed for creating a database in Excel.
Introduces object-oriented programming and provides a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language.
Walks through the switch to Access 2010 from Access 2003.
Explains the key differences between Access 2007 and Access 2003 and the benefits of upgrading to the 2007 version of Microsoft’s database design software.