Renaming Tables

  1. Notice the table names down the side under Queries. These are the names in the database, but they’re not very user-friendly. QueryList

  2. Rename the following queries to more friendly names by double-clicking the text/query:

    • Application vwCities to Cities
    • Sales vwCustomers to Customers
    • Sales vwOrderDetails to OrderDetails
    • Warehouse vw StockItems to StockItems
    • Application Countries to Countries
    • Dimension Date to Date

    Your queries should now look like this: QueryListFinished