Converting a lender list to a detailed database???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a lender list in access that is done as an Excel spreadsheet, with
Acct Exec. contact information. I want to make it more detailed as far as the
programs the lender offers, max LTV's, if they do seller seconds, minimum
credit score, max seller concessions, etc. I believe there is a way to make a
database and to transfer the info I already have into it. I shouldn't have to
retype all info on the Lender list right??

Thanks for any help!

Nicole
 
No, you don't have to retype the data. Before you start using Access, I
strongly recommend a little education. The most important thing is properly
structuring your data. If you simply import your spreadsheets and continue
working as if you were still using a spreadsheet, you will be veeeeery
unhappy with Access.

The data that you currently have in one sheet might need to be loaded into
several tables. Look for repeating groups. Those would be similarly named
columns that just have suffixes (acct1, acct2, etc) or represent periods of
time (Jan, Feb, Mar, etc). These need to be "normalized". Search for
"database design" and "normalization" for starters.

To import your spreadsheet into Access just to see what's what, use File/Get
external data/Import and find your spreadsheet in the browser. The wizard
will walk you through the import process.
 
Back
Top