Join Eric for a hands-on opportunity to learn the basics of SQL! He’ll cover basic SQL language, and some behind the scenes details on what SQL looks like, while at the same time covering how to use MS Access to create and edit queries.
Using Microsoft Access as the tool to build and run your queries, you’ll learn:
- Simple queries selecting data, counting data, and summarizing data.
- How to link tables together to build more sophisticated reports
- How to modify how tables are linked together to pull in information that only exists for some records but not others
- Concepts around database design for understanding of limitations of spreadsheets, why multiple tables are used, and some commentary of things to look for to make your life easier as you work with vendor tables and try to decipher why the vendors database is the way it is.
MS Access is very powerful and we’ll be scratching the surface on what it can do using it to make SQL more accessible. We’ll cover what SQL looks like providing basic understanding of both SQL and how to use MS Access to quickly generate queries to access and compile data. We’ll be focused on tables, queries and SQL in MS Access, the workshop will not cover forms, reports or other advanced MS Access topics.
This workshop will not cover how to do any web programming, or how to setup the database connections. For specific databases, the vendors will provide documentation on how to setup, and depending on security settings on your work machine, your IT folks may have to be involved.