Hi, I’m putting up my Access table/query names for critique, because at some point I’ll have to hand over this database to someone else and I want to see how they might react. So if you opened a query list and saw the list below, would you be able to find your way around, or are there too many similar looking queries?
Some of the queries are made up of 6 or 7 of the other queries – I find it’s easier to see what’s going on if they are separated out into individual queries, rather than throwing them all into a single select statement, and it means I can re-use things that I know work.
I get stuck on using plurals vs singular (e.g. StoresDeductions or StoreDeductions); how much detail to put in (e.g. BrokersChainsStoresCasesByMonth); how to indicate totals or being grouped by e.g. month; how to indicate date parameters, i.e. whenever a query says MonthRange it asks for this range, and any queries built on top of this one also have MonthRange in their name.
Any advice welcome. J
Some of the queries are made up of 6 or 7 of the other queries – I find it’s easier to see what’s going on if they are separated out into individual queries, rather than throwing them all into a single select statement, and it means I can re-use things that I know work.
I get stuck on using plurals vs singular (e.g. StoresDeductions or StoreDeductions); how much detail to put in (e.g. BrokersChainsStoresCasesByMonth); how to indicate totals or being grouped by e.g. month; how to indicate date parameters, i.e. whenever a query says MonthRange it asks for this range, and any queries built on top of this one also have MonthRange in their name.
Any advice welcome. J
Code:
Accounts
Code:
[SIZE=3][FONT=Calibri]AccountsTotalNumStores[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainDeductionsMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainDeductionsMonthRange_Crosstab[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainNumStores[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainsTotalsByMonthRange_Crosstab2[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsByMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsByMonthRange_Crosstab[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsPromoRatesMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersChainTotalsPromoRatesMonthRange_Crosstab[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersStoreDeductions[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersStoreDeductionsGroupedByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersStoreDeductionsMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersStoreTotalsByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]BrokersStoreTotalsMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]CasesPerActiveChainStorePerMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]CasesPerMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]CategoriesTotalShipped[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Chains[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsCasesPerStorePerMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsCasesShippedByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsMonthOfFirstOrder[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsMonthOfLastOrder[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsMonthsNumStoresCasesShipped[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsStoresOrderedPerMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainStoresPerMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsTotalNumStores[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsTotalNumStoresByNDIAgent[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsToWarehousesBroker[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsToWarehousesNDIAgent[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsToWarehousesOrderedByBroker[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]ChainsToWarehousesOrderedByNDIAgent[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByAccountGroupedByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByChain[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByChainNoStoreID[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByDistributor[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByStore[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsByType[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsNonStore[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsNumFreeCaseFillsByDistRef[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsPlacementFeePerFreeCaseFill[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsPlacementFeesByDistRef[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsPlacementFeesProRata[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsStoreByBroker[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]DeductionsStoreGroupedByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]MarketingByAccountByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoreOrdersByWarehouseByMonthRange[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresByMonthWithNumFreeCaseFills[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresCasesByProductByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresNotOrderedSinceDate[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresTotalShippedByMonth[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresTotalShippedByProduct[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresWithFreeCaseFills[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresWithFreeCaseFillsByProduct[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]StoresWithFreeCaseFillsNoOrderData[/FONT][/SIZE]