by Tom Chandler | Jun 30, 2022 | Uncategorized
A Microsoft Access database can have different types of tables including… Local information tablesLocal information tables store, in your local database, information you wish to track. This may include information about employees, clients, products, facilities,...
by Tom Chandler | Jun 29, 2022 | Uncategorized
This week’s Excel VBA macro shows you how to program a cut and paste action. Three examples are shown in the image above: The first uses four statements to cut a range of cells, reposition the cursor, paste, and finally turn off the cut/copy mode. The second example...
by Tom Chandler | Jun 28, 2022 | Uncategorized
Excel lets you apply multiple formatting features with either the mouse or the keyboard. Some keyboard shortcuts are intuitive, such as Ctrl B for Bold and Ctrl I for Italics. Some keyboard shortcuts are not intuitive. For example, Alt HFK decreases the font size. As...
by Tom Chandler | Feb 28, 2022 | Uncategorized
Ever wonder “How do I create a simple and easy to use PivotTable?” PivotTables are tools you can use in a spreadsheet to quickly create interactive summary reports (tables) from raw data. Because they are interactive, PivotTables allow you to easily do...
by Tom Chandler | Feb 20, 2022 | Uncategorized
Presidents’ Day this year is on Monday February 21, 2022. This is the day that citizens of the United States remember the service given by Washington, Lincoln, and other Presidents of the United States. As part of my remembrance I wanted to display...
