advanced microsoft access courses in london - database
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 » advanced microsoft access courses in london - Database

advanced microsoft access courses in london - Database

resolvedResolved · Low Priority · Version Standard

replyReply Tue 8 May 2007, 10:44Delegate 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?

For upcoming training course dates see: Pricing & availability

replyReply Thu 24 May 2007, 14:10Trainer 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

 

Access tip:

Undo Entries In Records

To Undo any entries or changes in records:

Hit the ESC key once for the current field

And ESC twice for current record

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