Access 2013 All-in-One For Dummies
-15%
portes grátis
Access 2013 All-in-One For Dummies
Stockman, Joseph C.; Barrows, Alison; Taylor, Allen G.
John Wiley & Sons Inc
04/2013
800
Mole
Inglês
9781118510551
15 a 20 dias
1380
Descrição não disponível.
Introduction 1 Book I: Getting Started with Access 2013 7
Chapter 1: Introducing Access 2013 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refi ning Your Table in Design View 105
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding "Garbage In, Garbage Out" 157
Chapter 6: Relating Your Tables and Protecting Your Data 175
Book III: Queries (Or Getting Information from Your Data) 187
Chapter 1: Creating Select Queries 189
Chapter 2: Letting Queries Do the Math 221
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255
Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277
Book IV: Forms for Editing Data 287
Chapter 1: Designing Custom Forms (and Reports) 289
Chapter 2: Jazzing Up Your Forms (and Reports) 313
Chapter 3: Creating Smarter Forms 339
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365
Book V: Reporting in Words and Pictures 385
Chapter 1: Creating and Spiffing Up Reports 387
Chapter 2: Printing Beautiful Reports 415
Chapter 3: Creating Charts and Graphs from Your Data 435
Book VI: Automation with Macros 457
Chapter 1: Making Macros Do the Work 459
Chapter 2: Making Macros Smarter 477
Book VII: Database Administration 497
Chapter 1: Database Housekeeping 499
Chapter 2: Sharing the Fun: Managing Multiuser Access 511
Chapter 3: Securing Your Data 523
Book VIII: Programming in VBA 535
Chapter 1: What the Heck Is VBA? 537
Chapter 2: Writing Code 557
Chapter 3: Writing Smarter Code 581
Chapter 4: Controlling Forms with VBA 605
Chapter 5: Using SQL and Recordsets 629
Chapter 6: Debugging Your Code 641
Book IX: Going Beyond Access 651
Chapter 1: Automation with Other Office Programs 653
Chapter 2: Using Access As a Front End to SQL Server 671
Chapter 3: Using Access with SharePoint 685
Appendix: Installing Microsoft Access 709
Index 717
Chapter 1: Introducing Access 2013 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refi ning Your Table in Design View 105
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding "Garbage In, Garbage Out" 157
Chapter 6: Relating Your Tables and Protecting Your Data 175
Book III: Queries (Or Getting Information from Your Data) 187
Chapter 1: Creating Select Queries 189
Chapter 2: Letting Queries Do the Math 221
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255
Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277
Book IV: Forms for Editing Data 287
Chapter 1: Designing Custom Forms (and Reports) 289
Chapter 2: Jazzing Up Your Forms (and Reports) 313
Chapter 3: Creating Smarter Forms 339
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365
Book V: Reporting in Words and Pictures 385
Chapter 1: Creating and Spiffing Up Reports 387
Chapter 2: Printing Beautiful Reports 415
Chapter 3: Creating Charts and Graphs from Your Data 435
Book VI: Automation with Macros 457
Chapter 1: Making Macros Do the Work 459
Chapter 2: Making Macros Smarter 477
Book VII: Database Administration 497
Chapter 1: Database Housekeeping 499
Chapter 2: Sharing the Fun: Managing Multiuser Access 511
Chapter 3: Securing Your Data 523
Book VIII: Programming in VBA 535
Chapter 1: What the Heck Is VBA? 537
Chapter 2: Writing Code 557
Chapter 3: Writing Smarter Code 581
Chapter 4: Controlling Forms with VBA 605
Chapter 5: Using SQL and Recordsets 629
Chapter 6: Debugging Your Code 641
Book IX: Going Beyond Access 651
Chapter 1: Automation with Other Office Programs 653
Chapter 2: Using Access As a Front End to SQL Server 671
Chapter 3: Using Access with SharePoint 685
Appendix: Installing Microsoft Access 709
Index 717
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
Access, Access 2013, Microsoft Access, Microsoft Access 2013, Microsoft Office Access, Microsoft Office Access 2013, databases, database software, Books on Access, guide to Access 2013, guide to Access, how to use Access, how to use Access 2013, instructions on Access 2013, Access 2013, Microsoft Office 2013, database software, using access, Access 2013 For Dummies, Access 2013 All-in-One For Dummies, Access 2013 for beginners, database creation, building a database, database management
Introduction 1 Book I: Getting Started with Access 2013 7
Chapter 1: Introducing Access 2013 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refi ning Your Table in Design View 105
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding "Garbage In, Garbage Out" 157
Chapter 6: Relating Your Tables and Protecting Your Data 175
Book III: Queries (Or Getting Information from Your Data) 187
Chapter 1: Creating Select Queries 189
Chapter 2: Letting Queries Do the Math 221
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255
Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277
Book IV: Forms for Editing Data 287
Chapter 1: Designing Custom Forms (and Reports) 289
Chapter 2: Jazzing Up Your Forms (and Reports) 313
Chapter 3: Creating Smarter Forms 339
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365
Book V: Reporting in Words and Pictures 385
Chapter 1: Creating and Spiffing Up Reports 387
Chapter 2: Printing Beautiful Reports 415
Chapter 3: Creating Charts and Graphs from Your Data 435
Book VI: Automation with Macros 457
Chapter 1: Making Macros Do the Work 459
Chapter 2: Making Macros Smarter 477
Book VII: Database Administration 497
Chapter 1: Database Housekeeping 499
Chapter 2: Sharing the Fun: Managing Multiuser Access 511
Chapter 3: Securing Your Data 523
Book VIII: Programming in VBA 535
Chapter 1: What the Heck Is VBA? 537
Chapter 2: Writing Code 557
Chapter 3: Writing Smarter Code 581
Chapter 4: Controlling Forms with VBA 605
Chapter 5: Using SQL and Recordsets 629
Chapter 6: Debugging Your Code 641
Book IX: Going Beyond Access 651
Chapter 1: Automation with Other Office Programs 653
Chapter 2: Using Access As a Front End to SQL Server 671
Chapter 3: Using Access with SharePoint 685
Appendix: Installing Microsoft Access 709
Index 717
Chapter 1: Introducing Access 2013 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refi ning Your Table in Design View 105
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding "Garbage In, Garbage Out" 157
Chapter 6: Relating Your Tables and Protecting Your Data 175
Book III: Queries (Or Getting Information from Your Data) 187
Chapter 1: Creating Select Queries 189
Chapter 2: Letting Queries Do the Math 221
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255
Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277
Book IV: Forms for Editing Data 287
Chapter 1: Designing Custom Forms (and Reports) 289
Chapter 2: Jazzing Up Your Forms (and Reports) 313
Chapter 3: Creating Smarter Forms 339
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365
Book V: Reporting in Words and Pictures 385
Chapter 1: Creating and Spiffing Up Reports 387
Chapter 2: Printing Beautiful Reports 415
Chapter 3: Creating Charts and Graphs from Your Data 435
Book VI: Automation with Macros 457
Chapter 1: Making Macros Do the Work 459
Chapter 2: Making Macros Smarter 477
Book VII: Database Administration 497
Chapter 1: Database Housekeeping 499
Chapter 2: Sharing the Fun: Managing Multiuser Access 511
Chapter 3: Securing Your Data 523
Book VIII: Programming in VBA 535
Chapter 1: What the Heck Is VBA? 537
Chapter 2: Writing Code 557
Chapter 3: Writing Smarter Code 581
Chapter 4: Controlling Forms with VBA 605
Chapter 5: Using SQL and Recordsets 629
Chapter 6: Debugging Your Code 641
Book IX: Going Beyond Access 651
Chapter 1: Automation with Other Office Programs 653
Chapter 2: Using Access As a Front End to SQL Server 671
Chapter 3: Using Access with SharePoint 685
Appendix: Installing Microsoft Access 709
Index 717
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
Access, Access 2013, Microsoft Access, Microsoft Access 2013, Microsoft Office Access, Microsoft Office Access 2013, databases, database software, Books on Access, guide to Access 2013, guide to Access, how to use Access, how to use Access 2013, instructions on Access 2013, Access 2013, Microsoft Office 2013, database software, using access, Access 2013 For Dummies, Access 2013 All-in-One For Dummies, Access 2013 for beginners, database creation, building a database, database management
