While I would never use MS Access for an multi-user application there are two features I love about MS Access, the first is the report generator. The report generator is a heck of a lot easier to use then Crystal Report. The second useful feature is the tool you use to build a query, it is easy to build a complex join with multiple tables.
In SQL Server 2005 is there such a tool to visually do joins between multiple tables? I've not seen anything about this but there is so much to learn on 2005 that I may have simply not come across it.
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …