GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database  >  Microsoft Access

 Print  |  
Question:  Explain dynasets in MS Access



July 07, 2008 03:30:54 #1
 saurav560   Member Since: January 2008    Total Comments: 2 

RE: Explain dynasets in MS Access
 
We building a Query and asking question to our database to get the answer.

What Information we going to pull from the query? we added the query and then we check result we see a table is being created. This table call a Dynasat . A dynaset is new table that is create temporally base on the table we chosen to work within our query. This Dynaset may not represent all the information that exist in a table there may thousand of record in a database but based on the question we ask it can only pull a few dozens. This dynaset is one that is update automatically because it not saved. Ever time a query is executed or call on this dynaset this new table is created base on our query information on the fly automatically its therefore for our use inside of reports form in other calculation and when we are done its disappear.
     

 

Back To Question