Expert Excel Examples | Expert Access Examples


Expert Excel Examples Banner




Expert Excel Consulting Examples and Expert Access Programming Examples

Below are a few of our Excel and Access examples, pulled from projects we have done in the recent past. They should give you an idea of the level of work we can do. At the bottom of the page are a series of free downloads. We also have other demos available, just click on the demo off to the right, I will send it to you right away. Most of the demos are all 2003 compatible, except for those on PowerPivot, etc.

Please check back often, as this page is still a work in progress, and additions will be made.

Make sure to check out our You-Tube Videos. We will frequently be adding new videos, so please check back.

Expert Excel Consultants on YouTube Training Videos


Expert Excel Consulting Examples

Click this Button to go to the Expet Excel Consultant Info WebPageExcel Example 1 (Jeff)

Excel Example 2

Free Excel and Access Demos

Please Request Demos below
(For E-Mail Delivery)


Expert Access Programming Examples

Click this Button to go to the Expert Access Programmer Info WebPageAccess Example 1

Access Example 2 (Helen)


Other Examples and Articles

Click this Button to go to the Excel and Access Consultants Info WebPage

Access Dual List-Box (Helen)

Excel Article 1 (Chris)

Access to Word (Helen)


Check out these Free Instant Downloads

This will take you to the Excel and Access Consultants Info WebPage

Excel and Access Integration Demo
How to send Data from Excel to Access using VBA Code. Check your References. You need Microsoft ActiveX Data Objects 2.1 Library. This demo is license free and completely modifiable.

Excel VLookup Demo (Chris S.)
This demo shows you several ways to do an Excel LOOKUP, VLOOKUP, Dynamic VLOOKUP, Dynamic HLOOKUP,and INDEX-MATCH.


Excel Chart Demo (Jacob)
This demo used Excel based VBA to populate several charts. Use the controls to manipulate the charts.

LNC Rename add-in (Access 2000-2003) (Helen) An add-in that renames database objects, and controls on forms and reports, according to the Leszynski Naming Convention (LNC). The Access 97 version of this add-in was originally featured in a three-part article series in Smart Access, in the summer of 1998. Works in Access 2000 through 2003.

LNC Rename add-in (Access 2007-2010) (Helen) An add-in that renames database objects, and controls on forms and reports, according to the Leszynski Naming Convention (LNC).  Works in Access 2007 through 2010.

Extras Plus add-in (Access 2003-2010) (Helen) Lets you back up front end Access databases and the most common types of back end databases (Access .mda and .accda, Excel .xls and .xlsx, comma-delimited and fixed-width text files), and make copies of database objects (individually or in groups); also lists table and query fields, by table field order or alphabetically.  Lets you specify a custom backup prefix or suffix for database object backups.  Works in Access 2002 or higher.

Access to Word (Helen) Using Embedded Templates for Exporting Access Data to Word.

Access ListBoxes (Helen) Access Archon article on Updated Paired Listboxes.

This will take you to the Excel and Access Consultants Info WebPage





My name is Christopher. Please phone (Toll-Free): 877-392-3539, or E-Mail:

Info@ExcelAndAccess.Co.Uk





    Home | Excel | Access | Macros | Consult | Programming | Support | LinkedIn A | LinkedIn B | Twitter | FaceBook | More



Disclaimer: The Microsoft Corporation is not associated with Excel and Access, LLC - UK, or this site. Microsoft Excel and Access are registered trademarks of Microsoft Corporation.

WebMaster Topher Web Designs Web Design & Internet Marketing by Topher Web Designs

We provide Expert Excel Examples and Expert Access Examples