25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | August 18, 2014

Ian Leslie: IMG Empathic Curiosity



Today, we wonder anxiously if digital media is changing our brains. But if there's any time in history when our mental operations changed... Continue »
  1. $18.89 Sale Hardcover add to wish list

spacer

Access 2007: The Missing Manual

by

Access 2007: The Missing Manual Cover

 

Synopses & Reviews

Publisher Comments:

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks — even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

Book News Annotation:

Intended for beginners, this guide explains how to create a database and adds tables, query and analyze data, print reports, and build data entry forms. More advanced chapters use macros and Visual Basic programming to automate complex tasks and solve common challenges, pull data out of other file types, and interact with SQL Server and SharePoint Server. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Written from the ground up for this redesigned application, this guide will help readers design and maintain complete databases, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.

About the Author

Matthew MacDonald is an author, educator, and programmer extraordinaire. He's the author of over a dozen books about .NET programming, and the author of Excel: The Missing Manual. In a dimly remembered past life, he studied English literature and theoretical physics.

Table of Contents

The Missing Credits Introduction Part I: Storing Information in Tables Chapter 1: Creating Your First Database Chapter 2: Building Smarter Tables Chapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and More Chapter 4: Blocking Bad Data Chapter 5: Linking Tables with Relationships Part II: Manipulating Data with Queries Chapter 6: Queries That Select Records Chapter 7: Essential Query Tricks Chapter 8: Queries That Update Records Chapter 9: Analyzing Data with Crosstab Queries and Pivot Tables Part III: Printing Reports Chapter 10: Creating Reports Chapter 11: Designing Advanced Reports Part IV: Building a User Interface with Forms Chapter 12: Creating Simple Forms Chapter 13: Designing Advanced Forms Chapter 14: Building a Navigation System Part V: Programming Access Chapter 15: Automating Tasks with Macros Chapter 16: Automating Tasks with Visual Basic Chapter 17: Writing Smarter Code Part VI: Sharing Access with the Rest of the World Chapter 18: Sharing a Database with Multiple Users Chapter 19: Importing and Exporting Data Chapter 20: Connecting Access to SQL Server Chapter 21: Connecting Access to SharePoint Part VII: Appendix Appendix A: Customizing the Quick Access Toolbar Colophon

Product Details

ISBN:
9780596527600
Author:
Macdonald, Matthew
Publisher:
Pogue Press
Author:
MacDonald, Matthew
Subject:
Operating Systems - Windows
Subject:
Database Management - General
Subject:
Database management
Subject:
Desktop Applications - MS Access
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Subject:
CourseSmart Subject Description
Subject:
Access;DBMS;Fields;Microsoft;Missing Manual;ODBC;Objects;Office;Queries;Query;SQL;Structured Query Language;Table;VB;Visual Basic;Windows applications;data;database;database design;databases;records;relational;relational databases;solutions;tables
Edition Description:
Print PDF
Series:
Missing Manual
Publication Date:
20070131
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
754
Dimensions:
9.1 x 7 x 1.5 in 2.16 lb

Other books you might like

  1. Access 2007 VBA Programming for...
    New Trade Paper $24.99
  2. The Little SAS Book: A Primer
    Used Trade Paper $29.00

Related Subjects


Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Databases

Access 2007: The Missing Manual New Trade Paper
0 stars - 0 reviews
$34.99 In Stock
Product details 754 pages Pogue Press - English 9780596527600 Reviews:
"Synopsis" by ,
Written from the ground up for this redesigned application, this guide will help readers design and maintain complete databases, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.