Access 2007 - The Missing Manual
Matthew MacDonald - Collection The Missing Manual
Résumé
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.
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.
L'auteur - Matthew MacDonald
Auteur et programmeur de talent, Matthew MacDonald a écrit plusieurs ouvrages de la collection Missing Manual et une dizaine de livres consacrés à la programmation avec la plateforme .NET de Microsoft.
Sommaire
- Storing Information in Tables
- Creating Your First Database
- Building Smarter Tables
- Mastering the Datasheet: Sorting, Searching, Filtering, and More
- Blocking Bad Data
- Linking Tables with Relationships
- Manipulating Data with Queries
- Queries That Select Records
- Essential Query Tricks
- Queries That Update Records
- Analyzing Data with Crosstab Queries and Pivot Tables
- Printing Reports
- Creating Reports
- Designing Advanced Reports
- Building a User Interface with Forms
- Creating Simple Forms
- Designing Advanced Forms
- Building a Navigation System
- Programming Access
- Automating Tasks with Macros
- Automating Tasks with Visual Basic
- Writing Smarter Code
- Sharing Access with the Rest of the World
- Sharing a Database with Multiple Users
- Importing and Exporting Data
- Connecting Access to SQL Server
- Connecting Access to SharePoint
- Appendix. Customizing the Quick Access Toolbar
Caractéristiques techniques
PAPIER | |
Éditeur(s) | O'Reilly |
Auteur(s) | Matthew MacDonald |
Collection | The Missing Manual |
Parution | 06/02/2007 |
Nb. de pages | 600 |
Format | 18 x 23 |
Couverture | Broché |
Poids | 1070g |
Intérieur | Noir et Blanc |
EAN13 | 9780596527600 |
ISBN13 | 978-0-596-52760-0 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse