Excel vs. Access: advice needed

[LennaK]

Hello,



I'm about to start a new project that will require a userform based listboxes/textboxes to filter and display data. I'm very familiar with Excel but don't have any Access experience. Instead of a spreadsheet, all of data will be stored in database tables, therefore, I will need to use Access to complete my project. I'm planning to find an on-line course to learn Access as soon as possible.

1. Could you recommend a good Access courses, preferably free or inexpensive.

2. Should I build a userform in Excel first and move it Access later after I learn how to use it, or should I wait until I'm ready to build everything in Access?

Thanks for your advice in advance,

Lenna

[June7]

1. many on-line tutorials, free and paid - here's one http://www.rogersaccesslibrary.com/

2. AFAIK, cannot copy/paste objects/controls between Excel and Access - might as well just build in Access

[DubCap01]

Hi LennaK

Depending on how much time you have on your hands, I'd choose to learn the basic in MS Access before trying to enter any data from MS Excel

User forms in Access are pretty simple to build, so don't worry about the import from Excel option - it doesn't work !

cheers
Pete

[orange]

There are tutorials here.

There several links in my post.
There are a number of youtube tutorials re Access. There is a series by 599CD starting here