Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-14 The Access Table Import Wizard.
AdventureWorks Access Database
The AdventureWorks database used in this topic is available also in Access format
on the companion DVD. You can open the AdventureWorks.zip file and extract the
AdventureWorks file in Access format. Copy it to your local disk before using it in
PowerPivot.
There is no practical difference between Access and a relational database when it comes
to loading tables. On the other hand, the SQL designer of Access is limited because it does
not offer a visual designer for the SQL query. When you query Access, you need to write the
query in a plain text editor, which you can see in Figure 5-15.
Search JabSto ::




Custom Search