Access 2010 Tables and Queries
Author(s): Mann, Lynn
Series: Microsoft Office 2010
College: Mt. San Jacinto College
Lynette Mann demonstrates and teaches how to design a database, considering information, table design, and relationships. She also covers Design View, Datasheet View, and Field Properties. Because MS Access is a relational database, tables have relationships to one another and these can be defined in several ways (e.g., one-to-many, many-to-many, etc.). Extracting data from Access - group data, summarized data, and top & bottom values - is also demonstrated.