title: Building user interface in Access or Excel
body: <p>I am trying to build a user interface which will allow users to choose what kind of information they want, then based on these selected conditions, I need to query an access database and retrieve the corresponding data for future calculation. During calculation, there are two additional tables that I will query from. Finally, I need to display the calculated results to users. Now I have some questions:</p>
  
  <ol>
  <li><p>Which one will be easier if I use excel as a front-end to users and retrieve querying data from Access to excel vs. I use access forms as a front-end to users and directly work with access to query data?</p></li>
  <li><p>Does access forms can perform functions like allow users to select options from a drop down list? and once options selected, Access will query the target info?</p></li>
  <li><p>Can Access perform intermediate calculation for large amount records? Will it get very slow? Compared to excel, which one is better in terms of calculation? </p></li>
  <li><p>I never use Access before and just know a little about Excel VBA, not totally familiar with it, not to mention object models. So, in this case, which way is time-saving for me? or they are probably the same time-consuming?</p></li>
  <li><p>Anything else that I should be aware of? </p></li>
  </ol>
  
  <p>Thanks so much!</p>
  
  <p>Bing </p>