Tagged Questions
3
votes
1answer
104 views
I need help to migrate denormalized table content to normalized form- MS Access
I have a staff database where we are storing information in Normalized form. There are 3 entity tables and 2 mapping tables connecting these with m-n relationships
However, for ease of collecting ...
1
vote
1answer
309 views
Ms Access queries equivalent in Sql Server
Queries in MS Access can act like views do in oracle in that you can query against them. Example: if you have a query in access called allProducts, you can also do
SELECT * from allProducts;
My ...