Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-15 The Access query designer in PowerPivot has few features.
Because the query designer of Access is so limited, if you need to load data from Access and
need help with SQL, it might be useful to write the query using the Access query designer,
directly in the Access application, as shown in Figure 5-16. Then after the query has been
built in Access, you can load the data from the query.
FIguRE 5-16 The Access query designer can be used to design Access queries.