Register your product to gain access to bonus material or receive a coupon.
Access 2013 Absolute Beginner's Guide
- By Alison Balter
- Published Apr 16, 2013 by Que. Part of the Absolute Beginner's Guide series.
Book
- Sorry, this book is no longer in print.
Description
- Copyright 2013
- Edition: 1st
- Book
- ISBN-10: 0-7897-4871-1
- ISBN-13: 978-0-7897-4871-3
Make the most of Access 2013—without becoming a technical expert! This book is the fastest way to master Access and use it to build powerful, useful databases of all kinds—even web application databases! Even if you’ve never used Access before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Access has never, ever been this simple!
Who knew how simple Access® 2013 could be? This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Access 2013 database program… simple, reliable instructions for doing everything you really
want to do! Here’s a small sample of what you’ll learn:
• Create tables to efficiently store and navigate your data
• Build queries that retrieve exactly the information you want
• Design intuitive forms that help your users work more efficiently
• Build reports that answer key questions intuitively and visually
• Learn easy techniques for designing more reliable databases
• Work faster with AutoForms, AutoReports, and other shortcuts
• Automate repetitive tasks and build more polished databases with macros
• Share Access data with Excel, SQL Server, and other applications
• Solve complex problems with advanced query, form, and reporting techniques
• Build modern web databases that serve users through browsers
• Run your database on the cloud through Microsoft Office 365
• Construct a complete database application from start to finish
• And much more…
Alison Balter, President of InfoTech Services Group, Inc., has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Access and has authored 14 books and videos for Pearson, including Microsoft Access 2010 LiveLessons and Alison Balter’s Mastering Access 2007 Development. She is past president of the Independent Computer Consultants Association of Los Angeles.
Category: Databases
Covers: Microsoft® Access® 2013
User Level: Beginning
Sample Content
Online Sample Chapter
Sample Pages
Download the sample pages (includes Chapter 1 and Index)
Table of Contents
Introduction.....................................................1
Who Should Read This Book.................................................................................... 1
How This Book Is Organized..................................................................................... 1
Requirements, Editions, and Features................................................................ 2
Using This Book.......................................................................................................... 5
1 Why Use Microsoft Access?...................7
What Is a Relational Database?................................................................................ 8
What Types of Things Can I Do with Microsoft Access?....................................... 8
Access as a Development Platform for Small-Business Applications.............. 9
Access as a Development Platform for Departmental Applications................ 9
Access as a Development Platform for Corporation-Wide Applications................10
Access as a Front End for Enterprisewide Client/Server Applications..................11
Access as a Tool to Develop Web Applications..............................................11
A Preview of the Database Components..............................................................11
Tables: A Repository for Data............................................................................11
Relationships: Tying the Tables Together........................................................14
Queries: Stored Questions or Actions You Apply to Data.............................16
Forms: A Means to Display, Modify, and Add Data.......................................17
Reports: Turning Data into Information............................................................18
Macros: A Means of Automating a System......................................................20
Modules: The Foundation of the Application Development Process...........21
2 Getting Started with Microsoft Access........................25
Creating a Database from a Template..................................................................26
Viewing Database Objects......................