Learn Access 2003 VBA With The Smart Method

3.83 avg rating
( 6 ratings by Goodreads )
 
9780955459900: Learn Access 2003 VBA With The Smart Method
View all copies of this ISBN edition:
 
 

Who is this book for?

If you've never written VBA code before this book will show you how.

This book is for Access developers who:

  • Are comfortable with all aspects of the interactive use of Access
  • Are already able to design simple relational databases
  • Want to learn VBA skills from first principles
  • Want to learn how to develop professional-grade Access applications

What you will learn

This unique book provides the easiest possible route to mastering professional  Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.

The emphasis throughout the book is on solid, professional coding practices and techniques. Instead of simple code snippets the book takes you through the process of developing a high-quality, sophisticated Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world commercial projects.

Amongst other things you'll learn how to:

  • Understand the Object-Orientated paradigm
  • Create a custom function library
  • Implement custom error handling to eliminate program crashes
  • Analyse, understand and improve wizard-generated code
  • Implement filters using option group controls
  • Add interactive help
  • Implement popup browse forms
  • Create self-updating combo boxes
  • Understand scope and use module-level and global-level constants
  • Implement VBA validations to enforce complex business rules
  • Create dialog-driven reports
  • Export Access data to Word document templates with a single click
  • Create an elegant user interface with custom menus and tool bars
  • Finalize applications for delivery to your clients

The Smart Method develop and run IT courses and have provided consultancy and training services to many of the world's largest companies in England, Europe and America. This book is also used as the basis of The Smart Method's Access VBA course. If you need to teach Access VBA this book is equally useful as courseware.

Companies who have taken Smart Method courses include:

AOL Time Warner, Daimler Chrysler, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Motorola, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks & Spencer, Virgin, 02, BMW .. and many, many others.

"synopsis" may belong to another edition of this title.

About the Author:

Mike Smart is the founder of The Smart Method Ltd who develop and run IT courses. Mike has trained delegates from many of the world's largest companies in England, Europe and America (see back cover of book for more details). Mike's unique teaching method is fun, absorbing and virtually 100% effective.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Smart, Mike
Published by The Smart Method Ltd (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description The Smart Method Ltd, 2007. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9780955459900

More information about this seller | Contact this seller

Buy New
US$ 24.74
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

Mike Smart
Published by The Smart Method Ltd, United Kingdom (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: 10
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description The Smart Method Ltd, United Kingdom, 2007. Paperback. Condition: New. Language: English. Brand new Book. Who is this book for?If you've never written VBA code before this book will show you how. This book is for Access developers who: Are comfortable with all aspects of the interactive use of AccessAre already able to design simple relational databasesWant to learn VBA skills from first principlesWant to learn how to develop professional-grade Access applicationsWhat you will learnThis unique book provides the easiest possible route to mastering professional Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.The emphasis throughout the book is on solid, professional coding practices and techniques. Instead of simple code snippets the book takes you through the process of developing a high-quality, sophisticated Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world commercial projects.Amongst other things you'll learn how to: Understand the Object-Orientated paradigmCreate a custom function libraryImplement custom error handling to eliminate program crashesAnalyse, understand and improve wizard-generated codeImplement filters using option group controlsAdd interactive helpImplement popup browse formsCreate self-updating combo boxesUnderstand scope and use module-level and global-level constantsImplement VBA validations to enforce complex business rulesCreate dialog-driven reportsExport Access data to Word document templates with a single clickCreate an elegant user interface with custom menus and tool barsFinalize applications for delivery to your clientsThe Smart Method develop and run IT courses and have provided consultancy and training services to many of the world's largest companies in England, Europe and America. This book is also used as the basis of The Smart Method's Access VBA course. If you need to teach Access VBA this book is equally useful as courseware. Companies who have taken Smart Method courses include: AOL Time Warner, Daimler Chrysler, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Motorola, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks & Spencer, Virgin, 02, BMW . and many, many others. Seller Inventory # AAV9780955459900

More information about this seller | Contact this seller

Buy New
US$ 29.45
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Mike Smart
Published by The Smart Method Ltd, United Kingdom (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: 10
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description The Smart Method Ltd, United Kingdom, 2007. Paperback. Condition: New. Language: English. Brand new Book. Who is this book for?If you've never written VBA code before this book will show you how. This book is for Access developers who: Are comfortable with all aspects of the interactive use of AccessAre already able to design simple relational databasesWant to learn VBA skills from first principlesWant to learn how to develop professional-grade Access applicationsWhat you will learnThis unique book provides the easiest possible route to mastering professional Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.The emphasis throughout the book is on solid, professional coding practices and techniques. Instead of simple code snippets the book takes you through the process of developing a high-quality, sophisticated Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world commercial projects.Amongst other things you'll learn how to: Understand the Object-Orientated paradigmCreate a custom function libraryImplement custom error handling to eliminate program crashesAnalyse, understand and improve wizard-generated codeImplement filters using option group controlsAdd interactive helpImplement popup browse formsCreate self-updating combo boxesUnderstand scope and use module-level and global-level constantsImplement VBA validations to enforce complex business rulesCreate dialog-driven reportsExport Access data to Word document templates with a single clickCreate an elegant user interface with custom menus and tool barsFinalize applications for delivery to your clientsThe Smart Method develop and run IT courses and have provided consultancy and training services to many of the world's largest companies in England, Europe and America. This book is also used as the basis of The Smart Method's Access VBA course. If you need to teach Access VBA this book is equally useful as courseware. Companies who have taken Smart Method courses include: AOL Time Warner, Daimler Chrysler, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Motorola, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks & Spencer, Virgin, 02, BMW . and many, many others. Seller Inventory # AAV9780955459900

More information about this seller | Contact this seller

Buy New
US$ 30.10
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

4.

Smart, Mike
Published by The Smart Method Ltd (2016)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: 1
Print on Demand
Seller:
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description The Smart Method Ltd, 2016. Paperback. Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Seller Inventory # ria9780955459900_lsuk

More information about this seller | Contact this seller

Buy New
US$ 25.56
Convert currency

Add to Basket

Shipping: US$ 5.04
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Mike Smart
Published by The Smart Method Ltd, United Kingdom (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description The Smart Method Ltd, United Kingdom, 2007. Paperback. Condition: New. Language: English. Brand new Book. Who is this book for?If you've never written VBA code before this book will show you how. This book is for Access developers who: Are comfortable with all aspects of the interactive use of AccessAre already able to design simple relational databasesWant to learn VBA skills from first principlesWant to learn how to develop professional-grade Access applicationsWhat you will learnThis unique book provides the easiest possible route to mastering professional Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.The emphasis throughout the book is on solid, professional coding practices and techniques. Instead of simple code snippets the book takes you through the process of developing a high-quality, sophisticated Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world commercial projects.Amongst other things you'll learn how to: Understand the Object-Orientated paradigmCreate a custom function libraryImplement custom error handling to eliminate program crashesAnalyse, understand and improve wizard-generated codeImplement filters using option group controlsAdd interactive helpImplement popup browse formsCreate self-updating combo boxesUnderstand scope and use module-level and global-level constantsImplement VBA validations to enforce complex business rulesCreate dialog-driven reportsExport Access data to Word document templates with a single clickCreate an elegant user interface with custom menus and tool barsFinalize applications for delivery to your clientsThe Smart Method develop and run IT courses and have provided consultancy and training services to many of the world's largest companies in England, Europe and America. This book is also used as the basis of The Smart Method's Access VBA course. If you need to teach Access VBA this book is equally useful as courseware. Companies who have taken Smart Method courses include: AOL Time Warner, Daimler Chrysler, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Motorola, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks & Spencer, Virgin, 02, BMW . and many, many others. Seller Inventory # LIE9780955459900

More information about this seller | Contact this seller

Buy New
US$ 33.40
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Smart, Mike
Published by Smart Method Ltd 1/1/2007 (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Smart Method Ltd 1/1/2007, 2007. Paperback or Softback. Condition: New. Learn Access 2003 VBA with the Smart Method. Book. Seller Inventory # BBS-9780955459900

More information about this seller | Contact this seller

Buy New
US$ 33.82
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Smart, Mike
Published by The Smart Method Ltd (2018)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(NORTH MIAMI BEACH, FL, U.S.A.)
Rating
[?]

Book Description The Smart Method Ltd, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 0955459907

More information about this seller | Contact this seller

Buy New
US$ 33.84
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Smart, Mike
Published by The Smart Method Ltd (2007)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description The Smart Method Ltd, 2007. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # LQ-9780955459900

More information about this seller | Contact this seller

Buy New
US$ 24.90
Convert currency

Add to Basket

Shipping: US$ 11.72
From United Kingdom to U.S.A.
Destination, rates & speeds

9.

Mike Smart
Published by Smart Method, Limited, The
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Smart Method, Limited, The. Paperback. Condition: New. 296 pages. Dimensions: 11.7in. x 8.3in. x 0.7in.Who is this book forIf youve never written VBA code before this book will show you how. This book is for Access developers who: Are comfortable with all aspects of the interactive use of AccessAre already able to design simple relational databasesWant to learn VBA skills from first principlesWant to learn how to develop professional-grade Access applicationsWhat you will learnThis unique book provides the easiest possible route to mastering professional Microsoft Access VBA programming. Both IT professionals and absolute beginners will love the book as it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way. The emphasis throughout the book is on solid, professional coding practices and techniques. Instead of simple code snippets the book takes you through the process of developing a high-quality, sophisticated Access application entirely from scratch. By the end of the course you will have a working and complete application that can be used as the basis for your own real-world commercial projects. Amongst other things youll learn how to: Understand the Object-Orientated paradigmCreate a custom function libraryImplement custom error handling to eliminate program crashesAnalyse, understand and improve wizard-generated codeImplement filters using option group controlsAdd interactive helpImplement popup browse formsCreate self-updating combo boxesUnderstand scope and use module-level and global-level constantsImplement VBA validations to enforce complex business rulesCreate dialog-driven reportsExport Access data to Word document templates with a single clickCreate an elegant user interface with custom menus and tool barsFinalize applications for delivery to your clientsThe Smart Method develop and run IT courses and have provided consultancy and training services to many of the worlds largest companies in England, Europe and America. This book is also used as the basis of The Smart Methods Access VBA course. If you need to teach Access VBA this book is equally useful as courseware. Companies who have taken Smart Method courses include: AOL Time Warner, Daimler Chrysler, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Motorola, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, Marks and Spencer, Virgin, 02, BMW . . and many, many others. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9780955459900

More information about this seller | Contact this seller

Buy New
US$ 37.96
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

10.

Mike Smart
Published by The Smart Method Ltd (2011)
ISBN 10: 0955459907 ISBN 13: 9780955459900
New Softcover Quantity Available: 15
Print on Demand
Seller:
Rating
[?]

Book Description The Smart Method Ltd, 2011. Condition: New. This item is printed on demand for shipment within 3 working days. Seller Inventory # LP9780955459900

More information about this seller | Contact this seller

Buy New
US$ 34.81
Convert currency

Add to Basket

Shipping: US$ 3.43
From Germany to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book