UALE Queries Module

We review the PowerPoint before getting into our query building.
Let’s import some data from Excel into our database. Download the OD interaction table above or from here.

Time to start learning the basic query: select query!

How about we append that data. This helps streamline our process of adding new data into a table.

Duplicates? Dang. We are going to learn how to find them and get rid of them.

Have I got some numbers for you. Here’s how to get them from a crosstab query.

Next module – Forms