simulation in Office

[Guest]

Since simulation requires vast amounts of input data, is there any element
within access that allows you to simulate scenarios from stored data?...if
not, is there any current considerations on how this may occur to aid
simulation in the near future?

 

[[MVP] S.Clark]

Describe in more detail, "simulate scenarios from stored data"

 

[Guest]

To carry out a 'simulation' a vast amount of data needs to be input i.e.
arrival rate of cars at a roundabout, number of people standing in a
queue-for simple examples. Access can be used to store this data. To actually
simulate some event for the furture , history of data is required, and a time
clock. What my question is asking is if in access there is any way of taking
data held in Access to use as input variables to a simulation, running with
random numbers and probability distributions to get an output which helps
analyse events for the future?