microsoft access training course - ms access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - MS Access

microsoft access training course - MS Access

resolvedResolved · Low Priority · Version Standard

replyReply Mon 5 Nov 2007, 16:45Delegate Rachel said...

Rachel has attended:
Access Introduction course

MS Access

Can I use data from MS Excel in MS Access? Is there a way of importing data from MS Excel to Access?

For upcoming training course dates see: Pricing & availability

replyReply Tue 6 Nov 2007, 10:17Trainer Richard said...

RE: MS Access

Yes, you can import Excel data to Access.

Use FILE > GET EXTERNAL DATA > IMPORT

This will start an import wizard, which will guide you throught the import process.

regards

Richard

replyReply Tue 6 Nov 2007, 10:27Delegate Rachel said...

RE: MS Access

Thanks for that, that's really helpful!

replyReply Tue 6 Nov 2007, 15:04Trainer Richard said...

RE: MS Access

Pleasure, if you have any other questions, feel free to add them to the forum.

Regards

Richard

 

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard