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

retrieving data access

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Retrieving Data from Access

Retrieving Data from Access

ResolvedVersion 2003

Steven has attended:
Excel Advanced course

Retrieving Data from Access

Is it possible to retrieve data from Access Databases using multiple entries from the same data column? e.g. I have a data table containing a list of part codes and RRPs and Descriptions for those part codes. I want to be able to enter a list of part codes into a column in Excel and retrieve the relevent RRPs and Descriptions from the Access Database.

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.