|
Access |
Working in Microsoft Access |
| Automation |
Using the Office Object Model through Automation |
| Environment |
Access application and database information |
| Forms |
Using Access forms, record movement, combo boxes, and
subforms |
| Macros and Modules |
Working with Access macros and modules |
| Objects |
Handling Access Objects such as ADP's, data operations, and
other Access objects |
| Reports |
Managing,
previewing, and printing Access reports |
| |
|
Active Server Pages |
Working with Microsoft Active Server Pages |
| Active Server Pages |
Samples of
ASP code for managing files, downloads, content, HTML forms,
etc. |
| |
|
ActiveX Controls |
Working with Windows ActiveX Controls |
| Windows Controls |
Using Windows common
controls, list view, and tree view |
| |
|
Database |
Working with Data |
|
Jet |
Supporting Access/Jet
databases through ADO, DAO, RDO, and ODBC Direct |
|
SQL Server |
Supporting SQL Server
through ADO and RDO using ODBC and OLE DB drivers |
| |
|
Excel |
Working with Microsoft Excel |
| Automation |
Creating
and modifying Excel spreadsheets from outside of Excel |
|
General |
Code
for use within Excel |
| |
|
Office
|
Working with Common Microsoft Office Objects |
| Automation |
Working with the
Office Assistant, command bars, and find file objects |
|
|
Outlook |
Working with Microsoft Outlook |
| Automation |
Manage Outlook mail, address book, contacts, folders, and
tasks |
| |
|
PowerPoint |
Working with Microsoft PowerPoint |
| Automation |
Creating
and modifying PowerPoint presentations from outside of
PowerPoint |
| |
|
VBA |
Common
Code for any VB/VBA Platform |
| Abstract Data Types |
Manipulation Abstract
Data Types such as bit arrays, history lists, queues, and
stacks |
| Application Techniques |
Managing dictionary
objects, message boxes, error handling, application shutdown |
| Clipboard Operations |
Get, set and clear the Windows Clipboard |
| Data Integrity |
16 and 32 bit Cyclic Redundancy Check (CRC) routines for
verifying data integrity |
| Date Type and Unit Conversion |
Bit conversion, data conversion (e.g. numbers to text),
standard unit and date conversions |
| Date and Time |
Date and time routines,
including business day calculations and timers |
| Encryption and Compression |
Encrypting and decrypting text and files using passwords,
Huffman compression, CLZ (Lempel-Ziv) compression, Run
Length Encoding (RLE), and UU encoding and decoding |
| File and Disk Operations |
Managing files, paths,
and disk drives using Windows APIs and native VB/VBA code |
| INI File |
Creating, reading, and
updating INI files |
| Internet and Web |
Internet protocols for managing FTP sites and HTTP sessions |
| Math |
Standard math routines for basic math, statistics,
trigonometry, area and volume |
| Multimedia |
Running and playing media
files such as AVI and WAV, plus CD and MIDI devices |
| References |
Managing library references in your project |
| Registry |
Reading, creating, and
modifying Windows System Registry setting |
| Searching and Sorting |
Searching
and sorting data in strings and arrays using algorithms such
as Boyer-Moore, fuzzy string search, metaphone, soundex,
binary, linear, bubble sort, quick sort, and shell sort |
| String Handling |
String manipulation for
concatenation, expression evaluation, tokenizer, parsing,
case conversion, quote cleaning, padding, and trimming |
| System Information |
Information on the computer, keyboard, memory, mouse, and
operating system |
|
Windows Common
Dialogs |
Display and prompt users
with the Windows Color, File, Font, Page Setup, and Print
dialogs |
| Windows Help |
Manage help files and jump to any section |
| |
|
Visual Basic |
Working
in Visual Basic |
| Application Techniques |
VB specific
routines to handle command line arguments, error handling,
hourglass, Windows shell |
| Controls |
VB data time picker, IP
Address input, data entry validation, combo boxes, list box,
text box, and toolbar |
| Forms |
Managing VB forms
including captionless windows |
| Graphics |
Graphics using the
Windows API and native VB commands including GDI support |
| Menus |
VB Menus including Most Recently Used (MRU) lists, and menu
bitmaps and states |
| Printing |
Managing printers and
drawing routines for printing |
| |
|
Word |
Working with Microsoft Word |
| Automation |
Creating
and modifying Microsoft Word documents from outside of Word |
| |
|
XML |
Code for
using the Microsoft XML Parser |
| XML DOM |
Create,
read, search and edit XML files; convert ADO recordsets to
XML, and display XML data in a tree view control |
