VBA

Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.

We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.

Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.

We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.

Are you getting the most out of Excel?

Excel is great at adding up numbers, but it can be used for so much more!!