Sams teach yourself Microsoft Access 2002 programming in 24 hours /

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 rea...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Kimmel, Paul
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Sams, ©2002.
Colección:Sams teach yourself in 24 hours series.
Temas:
Microsoft Access.
Microsoft Access (Computer file)
Database management.
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares