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
Resolved · Low Priority · Version Standard
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?
For upcoming training course dates see: Pricing & availability
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
|
