|
|
|
|
| LEADER |
04291nam a2200277 a 4500 |
| 001 |
1905841 |
| 005 |
20171111234742.0 |
| 008 |
070314s2007 nju o 001 0 eng d |
| 020 |
|
|
|a 9780470148044
|q (electronic bk.)
|
| 020 |
|
|
|a 0470148047
|q (electronic bk.)
|
| 020 |
|
|
|a 1280741910
|
| 020 |
|
|
|a 9781280741913
|q (pbk.)
|z 9780470046531
|q (pbk.)
|
| 040 |
|
|
|a N$T
|b eng
|e pn
|z 0470046538
|
| 050 |
|
4 |
|a QA76.9.D3
|b S76 2007eb
|
| 100 |
1 |
|
|a Stockman, Joseph C.
|
| 245 |
1 |
0 |
|a Access 2007 VBA programming for dummies /
|c by Joseph C. Stockman and Alan Simpson.
|
| 260 |
|
|
|a Hoboken, NJ :
|b Wiley,
|c ©2007.
|
| 300 |
|
|
|a 1 online resource (1 volume).
|
| 490 |
1 |
|
|a --For dummies
|
| 500 |
|
|
|a Includes index.
|
| 505 |
0 |
|
|a Cover -- TOC36;Table of Contents -- Introduction -- Part I Introducing VBA Programming -- CH36;Chapter 1 Where VBA Fits In -- Taking a Look at Access -- Understanding VBA -- Seeing Where VBA Lurks -- Finding Out How VBA Works -- CH36;Chapter 2 Your VBA Toolkit -- Using the Visual Basic Editor -- Referring to Objects from VBA -- Setting References to Object Libraries -- Using the Object Browser -- Searching the Object Library -- CH36;Chapter 3 Jumpstart58; Creating a Simple VBA Program -- Creating a Standard Module -- Creating a Procedure -- Understanding Syntax -- Using Existing Code -- Part II VBA Tools and Techniques -- CH36;Chapter 4 Understanding Your VBA Building Blocks -- Commenting Your Code -- Understanding VBA Data Types -- Passing Data to Procedures -- Repeating Chunks of Code with Loops -- Making Decisions in VBA Code -- CH36;Chapter 5 Controlling Access through VBA -- Understanding Object Models -- Manipulating Properties and Methods -- CH36;Chapter 6 Programming Access Forms -- Working with Class Procedures -- Enabling or Disabling Form Controls -- Responding to Form Events -- Changing the Appearance of Objects -- Opening and Closing Forms -- Part III VBA44; Recordsets44; and SQL -- CH36;Chapter 7 The Scoop on SQL and Recordsets -- What the Heck Is SQL63; -- Creating Tables from VBA -- Adding Records to a Table -- Changing and Deleting Table Records -- Performing an Action Query on One Record -- Working with Select Queries and Recordsets -- CH36;Chapter 8 Putting Recordsets to Work -- Looping through Collections -- Tips on Reading and Modifying Code -- Skipping Over Used Mailing Labels -- Looking at How Skip Labels Works -- Calling a Procedure from an Event -- Part IV Applying VBA in the Real World -- CH36;Chapter 9 Creating Your Own Dialog Boxes -- Displaying and Responding to Messages -- Converting Forms to Dialog Boxes -- Creating Custom Combo Boxes -- Creating a Spin Box Control -- Detecting a Right45;Click -- CH36;Chapter 10 Customizing Combo Boxes and List Boxes -- Programming Combo and List Boxes -- Linking Lists -- Linking Lists across Forms -- More Combo Box Tricks -- CH36;Chapter 11 Creating Your Own Functions -- The Role of Functions in VBA -- Creating Your Own Functions -- A Proper Case Function -- A Function to Print Check Amounts -- CH36;Chapter 12 Testing and Debugging Your Code -- Understanding Compilation and Runtime -- Considering Types of Program Errors -- Conquering Compile Errors -- Dealing with Logical Errors -- Wrestling Runtime Errors -- Part V Reaching Out with VBA -- CH36;Chapter 13 Using VBA with Multiple Databases -- Client45;Server Microsoft Access -- Importing from External Databases -- Linking to External Data through Code -- Avoiding Multiple Tables and Links -- Creating Recordsets from External Tables -- Importing44; Exporting44; or Linking to Anything -- CH36;Chapter 14 Integrating with Other Office Applications -- Accessing the Object Library -- Sending E45;Mail via Outlook -- Sending Data to Microsoft Word -- Interacting with Microsoft Excel -- Part VI The Part of Tens -- CH36;Chapter 15 Ten Commandments of Writing VBA -- I46; Thou Shalt Not Harbor Strange Beliefs about Microsoft Access -- II46; Thou Shalt Not Use VBA Statements in Vain -- III46; Remember to Keep Holy the VBA Syntax -- IV.
|
| 650 |
|
0 |
|a Database management.
|
| 650 |
|
7 |
|a COMPUTERS
|x Programming Languages
|x SQL.
|
| 700 |
1 |
|
|a Simpson, Alan,
|
| 856 |
4 |
0 |
|u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=185562
|
| 952 |
|
|
|a CY-NiOUC
|b 5a0466a16c5ad14ac1eef378
|c 998a
|d 945l
|e -
|t 1
|x m
|z Books
|
