| Description |
1 online resource (xix, 549 pages) : illustrations |
|
text file |
| Series |
Sams teach yourself |
|
Sams teach yourself in 24 hours series.
|
| Contents |
Cover -- Contents at a Glance -- TOC36;Contents -- Introduction -- PART I Access Programming 101 -- CH36;HOUR 1 Whats New in Access 2002 -- New Side Panes for Easier Navigation -- Customizing Menus and Toolbars -- Spell45;Checking Data -- Editing Options -- Speech Command and Control -- Collaborating Online -- Network Places -- Remove Author Information -- Introducing ActiveX Data Objects -- Programming Objects -- Adding Data to Web Pages -- Access Projects -- Summary -- Q38;A -- Workshop -- CH36;HOUR 2 Exploring VBA -- Understanding How Access VBA Works -- Learning Access VBA Keywords -- Access Operators and Operands -- Data58; What a Program Knows -- Putting It All Together -- Prelude to Advanced Topics -- Summary -- Q38;A -- Workshop -- CH36;HOUR 3 Storing Your Programs Data -- How Memory Is Used -- Declaring Variables -- Data Assignment and Evaluation -- Be Explicit -- Using Pop45;up Hints -- Using the Locals Window -- Using the Watches Window -- Running Code in the Immediate Window -- Employing the Call Stack -- Summary -- Q38;A -- Workshop -- CH36;HOUR 4 Controlling Program Flow and Performing Calculations -- What Goes into an Equation -- Understanding Operator Count -- Using Arithmetic Operators -- Performing Comparisons -- The Truth of Logical Operators -- Concatenate It -- Who Has Precedence Here63; -- Special Operators -- Summary -- Q38;A -- Workshop -- PART II Writing Code to Manage Your Access Data -- CH36;HOUR 5 Learning to Write Conditional Code -- A Programmers Traffic Cop -- Tidying Up Nested Conditional Statements -- Want to Go for a Spin63; -- Take It Once Around the Block -- Iterating Through Data -- Iterating Collections of Data -- Short45;circuiting Code -- Using the Switch Function -- Summary -- Q38;A -- Workshop -- CH36;HOUR 6 Managing Your Database -- Access 2002 Is Backward Compatible with Access 2000 -- Creating a Database -- Managing a Table with Code -- Iteratively Inputting User Data -- Using Conditional Code to Find Data -- Summary -- Q38;A -- Workshop -- CH36;HOUR 7 Using Advanced Data Types to Manage Data -- Understanding OLE Automation -- Using the ADODB Object -- Using the ADOX Object -- Summary -- Q38;A -- Workshop -- PART III Using Access Resources to Get the Job Done -- CH36;HOUR 8 Solving Problems a Piece at a Time -- The Mechanics of Writing Subroutines -- The Mechanics of Writing Functions -- Programming Rules of Thumb -- Tying It All Together -- Summary -- Q38;A -- Workshop -- CH36;HOUR 9 Using Macros As Learning Aids -- Creating a Macro 101 -- Using CopyObject -- Using DeleteObject -- The Keys to the City -- Importing Data -- Using Macro Resources in Code -- To Macro or Not to Macro -- Summary -- Q38;A -- Workshop -- CH36;HOUR 10 Employing Access Predefined Solutions -- Using String45;Handling Functions -- Formatting Data -- Using Date and Time Functions -- Managing File I47;O -- Dynamic User Input Functions -- Using Function44; Method44; Property44; and Statement References -- Summary -- Q38;A -- T$10734. |
| Summary |
Sams Teach Yourself Access 10 Programming in 24 Hours will considerably improve the quality of the database applications that the reader can create with Microsoft Access. Concise tutorials that quickly bring the reader up to speed will be the goal of each chapter. Having completed this book, the readers will be able to understand any sample VBA code that they see, and will possess the skills to attack all of the most common Access programming tasks. Topics covered in the book will include: using data aware controls; creating data aware Web pages; creating views to organize data; building reusable code modules; programming reports; communicating results with graphing; automating contact and task management with Outlook; and Access programming for Internet Explorer. |
| Subject |
Microsoft Access.
|
|
Microsoft Access (Computer file) |
|
Microsoft Access. |
|
Microsoft Access |
|
Database management.
|
|
Bases de données -- Gestion. |
|
Database management. |
|
Database management |
| Other Form: |
Print version: Kimmel, Paul. Sams teach yourself Microsoft Access 2002 programming in 24 hours. Indianapolis, Ind. : Sams, ©2002 0672320983 (DLC) 00109719 (OCoLC)46944818 |
| ISBN |
0768657865 (electronic bk.) |
|
9780768657869 (electronic bk.) |
|
9780768683660 |
|
0768683661 |
|
More Resources