advanced microsoft access courses in london

advanced microsoft access courses in london - Database

Resolved · Low Priority · Version Standard

Database

Vishal has attended:
Access Intermediate course
Access Advanced course

by - delegate Vishal [4 posts] (2007 May 8 Tue, 10:44) Reply

How can I link my access results in to a database which would let me search on any information which is in the access results, E.g. Search by Fist name, surname, postcode or Date of purchase.

Any can I do this across several access sheets to one database?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Database

by - trainer Richard platinum contributer [818 posts] (2007 May 24 Thu, 14:10) Reply

In access, similar data must be stotred in the same table. You are not able to search access multiple tables in access. You could use the APPEND Query to add them all to one table.

Alternatively, you must link the tables together with relationships to create a multi table search.

regards

richard