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.

nexusstc/Access 2007: The Missing Manual/4057b9cb8ccbb70c993aa3d5e7c6fe3e.pdf

zlib/Computers/Networking/Matthew MacDonald/Access 2007: The Missing Manual_738597.pdf

Access 2007 for Starters

Мэтью Мак-Дональд; [пер. с англ. Т. Коротяевой]

MacDonald, Matthew

Мак-Дональд, Мэтью

Русская Ред.; БХВ-Петербург

Pogue Press

The Missing manual, 1st ed., Beijing, Sebastopol, CA, China, 2007

Недостающее руководство, Москва, Russia, 2007

United States, United States of America

O'Reilly Media, Sebastopol, 2007

Missing manual, Farnham, 2007

Sebastopol, Calif, 2006

December 29, 2006

1, PS, 2007

0

lg312374

{"edition":"1","isbns":["0596527608","9780596527600"],"last_page":752,"publisher":"O'Reilly Media","series":"The Missing Manual Series"}

Includes index.

Указ.
Пер.: MacDonald, Matthew Access 2007 Beijing [etc.]: O'Reilly, 2007 (cop.) 978-0-596-52760-0

РГБ

Russian State Library [rgb] MARC:
=001 003329999
=005 20071123124546.0
=008 071010s2007\\\\ru\\\\\\\\\\\\000\|\rus|d
=017 \\ $a 07-69402
=020 \\ $a 978-5-7502-0343-3 (Русская Редакция)
=020 \\ $a 978-5-9775-0093-7 (БХВ-Петербург)
=040 \\ $a RuMoRKP $b rus $d RuMoRGB
=041 1\ $a rus $h eng
=080 \\ $a 004.42
=084 \\ $a З973.26-018.2-5-05,0 $2 rubbk
=100 1\ $a Мак-Дональд, Мэтью
=245 00 $a Access 2007 $c Мэтью Мак-Дональд ; [пер. с англ. Т. Коротяевой]
=260 \\ $a Москва $b Русская Ред. $b БХВ-Петербург $c 2007
=300 \\ $a 765 с. $b ил., табл. $c 23 см
=490 0\ $a Недостающее руководство
=500 \\ $a Указ.
=534 \\ $p Пер.: $a MacDonald, Matthew $t Access 2007 $c Beijing [etc.]: O'Reilly, 2007 (cop.) $z 978-0-596-52760-0
=650 \7 $a Вычислительная техника -- Вычислительные машины электронные цифровые -- Персональные компьютеры -- Программирование -- Операционные системы. Базы данных -- Автоматизация. Управление $2 rubbk
=653 \\ $a хранение данных в таблицах
=653 \\ $a обработка данных с помощью запросов
=653 \\ $a отчеты в ПК
=653 \\ $a пользовательский интерфейс
=653 \\ $a программирование в Access
=852 \\ $a РГБ $b FB $j 3 07-34/82 $x 90

Access 2007: The Missing Manual ......Page 0
Table of Contents......Page 1
Copyright......Page 5
The Missing Credits......Page 7
Introduction......Page 11
Part I: Storing Information in Tables......Page 31
1. Creating Your First Database......Page 32
Section 1.1. Understanding Access Databases......Page 33
Section 1.2. Getting Started......Page 34
Section 1.3. Saving and Opening Access Databases......Page 50
Section 1.4. The Navigation Pane......Page 61
2. Building Smarter Tables......Page 65
Section 2.1. Understanding Data Types......Page 66
Section 2.2. Design View......Page 68
Section 2.3. Access Data Types......Page 73
Section 2.4. The Primary Key......Page 93
Section 2.5. Six Principles of Database Design......Page 96
3. Datasheet: Sorting, Searching, Filtering......Page 101
Section 3.1. Datasheet Customization......Page 102
Section 3.2. Datasheet Navigation......Page 108
Section 3.3. Advanced Editing......Page 121
Section 3.4. Printing the Datasheet......Page 128
4. Blocking Bad Data......Page 132
Section 4.1. Data Integrity Basics......Page 133
Section 4.2. Input Masks......Page 145
Section 4.3. Validation Rules......Page 155
Section 4.4. Lookups......Page 163
5. Linking Tables with Relationships......Page 169
Section 5.1. Relationship Basics......Page 170
Section 5.2. Using a Relationship......Page 176
Section 5.3. More Exotic Relationships......Page 192
Section 5.4. Relationship Practice......Page 198
Part II: Manipulating Data with Queries......Page 205
6. Queries That Select Records......Page 206
Section 6.1. Query Basics......Page 207
Section 6.2. Creating Queries......Page 208
Section 6.3. Queries and Related Tables......Page 229
7. Essential Query Tricks......Page 240
Section 7.1. Calculated Fields......Page 241
Section 7.2. Query Functions......Page 249
Section 7.3. Summarizing Data......Page 263
Section 7.4. Query Parameters......Page 270
8. Queries That Update Records......Page 273
Section 8.1. Understanding Action Queries......Page 274
Section 8.2. Update Queries......Page 276
Section 8.3. Append Queries......Page 283
Section 8.4. Delete Queries......Page 292
Section 8.5. Tutorial: Flagging Out-of-Stock Orders......Page 296
9. Crosstab Queries and Pivot Tables......Page 299
Section 9.1. Understanding Crosstab Queries......Page 300
Section 9.2. Creating Crosstab Queries......Page 304
Section 9.3. Pivot Tables......Page 313
Section 9.4. Pivot Charts......Page 326
Part III: Printing Reports......Page 332
10. Creating Reports......Page 333
10.1. Report Basics......Page 337
10.2. Printing, Previewing, and Exporting a Report......Page 347
10.3. Formatting a Report......Page 354
10.4. Filtering and Sorting a Report......Page 355
11. Designing Advanced Reports......Page 358
Section 11.1. Improving Reports in Design View......Page 359
Section 11.2. The Report Wizard......Page 370
Section 11.3. The Label Wizard......Page 374
Section 11.4. Fine-Tuning Reports with Properties......Page 379
Section 11.5. Expressions......Page 385
Section 11.6. Grouping......Page 387
Part IV: Building a User Interface with Forms......Page 399
12. Creating Simple Forms......Page 400
Section 12.1. Form Basics......Page 401
Section 12.2. Sorting and Filtering in a Form......Page 412
Section 12.3. Creating Better Layouts......Page 417
Section 12.4. The Form Wizard......Page 429
13. Designing Advanced Forms......Page 432
Section 13.1. Customizing Forms in Design View......Page 433
Section 13.2. Taking Control of Controls......Page 450
Section 13.3. Forms and Linked Tables......Page 462
14. Building a Navigation System......Page 466
Section 14.1. Mastering the Navigation Pane......Page 467
Section 14.2. Building Forms with Navigation Smarts......Page 478
Section 14.3. Linking to Related Data......Page 490
Part V: Programming Access......Page 498
15. Automating Tasks with Macros......Page 499
Section 15.1. Macro Essentials......Page 500
Section 15.2. Macros and Security......Page 509
Section 15.3. Three Macro Recipes......Page 517
Section 15.4. Managing Macros......Page 523
Section 15.5. Connecting Macros to Forms......Page 527
Section 15.6. Conditional Macros......Page 534
16. Automating Tasks with Visual Basic......Page 540
Section 16.1. The Visual Basic Editor......Page 541
Section 16.2. Putting Code in a Form......Page 546
Section 16.3. Understanding Objects......Page 553
Section 16.4. Using Objects......Page 563
17. Writing Smarter Code......Page 574
Section 17.1. Exploring the VB Language......Page 575
Section 17.2. Dealing with Trouble......Page 586
Section 17.3. Deeper into Objects......Page 592
Section 17.4. Using VB to Run a Better Business......Page 599
Part VI: Sharing Access with the WWW ......Page 614
18. Sharing a Database with Multiple Users......Page 615
Section 18.1. Opening Up Your Database to the World......Page 616
Section 18.2. Preparing Your Database......Page 618
Section 18.3. Playing Well with Others......Page 633
Section 18.4. Data Corruption......Page 640
Section 18.5. Securing Your Database......Page 642
19. Importing and Exporting Data......Page 650
Section 19.1. Case for Importing and Exporting......Page 651
Section 19.2. Using the Clipboard......Page 654
Section 19.3. Import and Export Operations......Page 659
Section 19.4. Access and XML......Page 671
Section 19.5. Collecting Info by Email......Page 681
20. Connecting Access to SQL Server......Page 691
Section 20.1. Should You Switch to SQL Server?......Page 692
Section 20.2. Getting Started: SQL Server 2005 Express......Page 697
Section 20.3. Creating a SQL Server Database......Page 703
Section 20.4. Adding Objects to a SQL Server Database......Page 713
21. Connecting Access to SharePoint......Page 723
Section 21.1. Understanding SharePoint......Page 724
Section 21.2. Setting Up SharePoint......Page 729
Section 21.3. SharePoint and Access......Page 739
Part VII: Appendix......Page 764
Appendix A. Customizing the Quick Access Toolbar......Page 765
Section A.1. The Quick Access Toolbar......Page 766
Colophon......Page 770
INDEX ......Page 771
Symbol ......Page 772
A......Page 774
B......Page 779
C......Page 781
D......Page 788
E......Page 795
F......Page 799
G......Page 806
H......Page 808
I......Page 809
J......Page 811
K......Page 812
L......Page 813
M......Page 816
N......Page 819
O......Page 821
P......Page 824
Q......Page 828
R......Page 830
S......Page 834
T......Page 840
U......Page 843
V......Page 845
W......Page 847
X......Page 849
Y......Page 850
Z......Page 851

A comprehensive guide to Access 2007 helps users become comfortable with the new user interface and tabbed toolbar, as well as learn how to design complete databases, maintain them, write queries, search for data, and build attractive forms for quick-and-easy data entry.

2010-10-03