Weighted Average Calculations A normal average calculation sums values and then divides by the number of values. This basic average calculation works fine unless you need to give a different weight to each value. For example, our students take 5 exams a year and we need to calculate their overall percentage at the end of…Read More
Using the FileSytemObject The FileSystemObject (FSO) provides a useful way to access the filing system on your computer and network drives. To use the FSO you first need to create a reference to the Microsoft Scripting Runtime Library.
VIDEO TRAINING - LEARN AT YOUR OWN PACE
DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECT. Click here to enrol
THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol
In the VBE click Tools | References. Check the option Microsoft Scripting Runtime and… Read More
What is an Array? An array, like a variable is a somewhere to store data. An array can however hold more than one value, for example an entire database of information with tens of thousands of records. Using arrays in your procedures makes your code potentially quicker than alternative methods for say performing calculations on…Read More