access-database-training - new queries linking to excel spreadsheets

The UK's most regular instructor-led training courses.
Training information: access-database-training · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

new queries linking to excel spreadsheets

Sarah has attended:
Access Introduction course

by - delegate Sarah [1 post] (2007 Feb 21 Wed, 09:46) Reply

how to set up new queries?

linking database to spreadsheets?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Southwark	0	FULL
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	7	book now	£190	£224
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
Full Schedule: See all 54 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: new queries linking to excel spreadsheets

by - trainer Orok bronze contributer [29 posts] (2007 Feb 22 Thu, 15:50) Reply

Hello Sarah,

Setting up queries is covered on the Access Introduction course.

The File / Import facility allows the linking of Acess to Excel spreadsheets. This is discuss on the Introduction course, last topic of the day under importing

Regards

· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Why a Microsoft Access Course Could Change the Way You Do Business
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· 3 Useful Things You'll Learn in Microsoft Access Training Courses

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips