Just trying to get started on Access

C

Catherine

I've just been given the task of setting up a database for my company and
although I have used Access many years ago I have never set one up before. I
have tow simple questions.
1) our current customer contact information is in an excel spreadsheet and I
want to know if I will be able to copy this straight into an Access table or
am I going to have to input again from scratch.
2) once a form is created will I be able to add additional information boxes
at a later stage?

Thanks
 
N

Nikos Yannacopoulos

Catherine,
1) our current customer contact information is in an excel spreadsheet and I
want to know if I will be able to copy this straight into an Access table or
am I going to have to input again from scratch.
Click to expand...
Yes, you can create a table into Access and paste from Excel, but it
gets better! While in Access, go File > Get External Data > Import and
let the wizard guide you to import the Excel sheet into a new table taht
Access will automatically create for you.

2) once a form is created will I be able to add additional information boxes
at a later stage?
Click to expand...
Yes. Again, it gets better: once the table is created, select it in the
database window and go Insert > AutoForm; Access will automatically make
a form for you, which you can then modify as you like.

HTH,
Nikos
 
Top