What you’ll learn to do: Analyze data

In this section we will explore a variety of topics that support data analysis. First, data must be “cleaned” in order to be useful. This process is known as data transformation and Access has several features that aid in preparing data for analysis purposes. Next, we will explore the rich set of calculations built-in to Access to be used for data analysis. Finally, we will touch on some more complex topics: conditional analysis and subqueries—very powerful tools of relational databases to get the most of data analysis.