Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access courses in london - Database

advanced microsoft access courses in london - Database

ResolvedVersion Standard

Tue 8 May 2007, 10:44 Delegate Vishal said...

Vishal has attended:
Access Intermediate course
Access Advanced course

Database

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?

Thu 24 May 2007, 14:10 Trainer Richard said...

RE: Database

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy