Read more
Informationen zum Autor Alison Barrows is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books. Klappentext Get started with the new Access 2013 with this impressive all-in-one reference!Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data locally, getting up to speed on the latest features of Access 2013, creating queries and macros, and much more. From the basics to advanced functions, this book is what you need to make Access more accessible.* Shows you how to store, organize, view, analyze, and share data using Access 2013* Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the web* Helps you build database solutions that integrate with the web and other enterprise data solutions* Offers plenty of techniques, tips, and tricks to help you get the most out of AccessThis all-in-one guide offers you access to all things Access 2013! Zusammenfassung Get started with the new Access 2013 with this impressive all-in-one reference!Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data locally, getting up to speed on the latest features of Access 2013, creating queries and macros, and much more. From the basics to advanced functions, this book is what you need to make Access more accessible.* Shows you how to store, organize, view, analyze, and share data using Access 2013* Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the web* Helps you build database solutions that integrate with the web and other enterprise data solutions* Offers plenty of techniques, tips, and tricks to help you get the most out of AccessThis all-in-one guide offers you access to all things Access 2013! Inhaltsverzeichnis Introduction 1Book I: Getting Started with Access 2013 7Chapter 1: Introducing Access 2013 9Chapter 2: Getting Started, Getting Around 17Chapter 3: Designing Your Database the Relational Way 37Book II: Tables for Storing Your Data 65Chapter 1: Creating and Modifying Tables 67Chapter 2: Refi ning Your Table in Design View 105Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121Chapter 4: Importing and Exporting Data 137Chapter 5: Avoiding "Garbage In, Garbage Out" 157Chapter 6: Relating Your Tables and Protecting Your Data 175Book III: Queries (Or Getting Information from Your Data) 187Chapter 1: Creating Select Queries 189Chapter 2: Letting Queries Do the Math 221Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277...
