Microsoft Access Database Configuration

Figure CC-7: Configure Microsoft Access Select Statement

Add Ons Desktops Net Books Laptops PDA Mac Gaming Products Nintendo Gaming Products PC Gaming Products Play Station 3 Games Sony PSP Gaming Products Wii Gaming Products Xbox Gaming Products Accessories Blue Tooth Car Electronics Cell Phones & Service GPS Devices Home Theater Marine Electronics Mobile Broadband Office Products Photography Products Precision Measurement Security Products Video Products Business Software Graphics Software Mac Software Multimedia Networking Software Operating Systems Programming Software Security Software Utilities Web Development Apple Computer Books Certification Books Business Books Database Books Computer Hardware Computer Networking Computer Programming Computer Science Computer Security Digital Music Digital Photography Game Strategy Books General Computer Graphics Design Microsoft Computing Mobile Wireless Operating Systems Science Books Technical Books Web Development

Configure the Select statement to retrieve data from the Products category as indicated in the diagram above. Also check the following columns:

• ProductID
• Name
• ShortDescription
• LongDescription
• ImageFile
• UnitPrice

After making all of the proper selections, press the Next button on the dialog box. This will bring up the Test Query dialog box as illustrated in the diagram below:

\ Figure CC-8: Microsoft Access Database Test Query Dialog Box

Help Support Mr. Centurion - Donate or Visit any Sponsor

No Purchase Necessary. Help us keep this site operational by making a donation. Any amount is greatly appreciated. OR, if you visit our sponsor, they will make a donation for you, just for visiting. Thank you

It is a good idea to press the Test Query button, to make sure all of the entries are correct, unless you really know what you're doing, in which case you probably wouldn't be here, reading this tutorial. When you press the Test Query button, the textbox control should fill with Part Numbers, Names, Description, etc. If it does not, some previous step has a small error, and you will need to go back and correct it. Otherwise, you're probably good, and you can press the Finish button, and celebrate your success by clicking on a few Google Ads, and get some free software or something.

Once we've all finished celebrating, we need to come back to reality, and realize, that there is still more work to do, and we shouldn't be wasting all of our time clicking those Google Ads, no matter how much fun we may think it is. To the right of the Drop Down List is a little arrow, which displays the Smart Tag, but it is a little hard to see. Other than that, if you right-click on the drop-down list, the Properties Dialog Box is displayed, in the manner we are used to and come have to know and love. Doing so brings up the properties Dialog Box, with the Smart Tag option. Select the Smart Tag option as indicated in the illustration below:

Figure CC-9: Drop Down List Smart Tag

Excellent Tech Support - Centurion Approved

Selecting the Smart Tag option brings up the following dialog box:

Figure CC-10: Choose Data Source for Drop Down List

Selecting the Choose Data Source option brings up the Choose Data Source Dialog Box as illustrated in the diagram below:

Figure CC-10: Choose Drop Down List Access Data Source Dialog Box

Choose:

• AccessDataSource1 → ddlProducts.DataSource


• Name → ddlProducts.FieldToDisplay


• ProductID → ddlProducts.DataFieldValue

for the available option selections in the Data Source Dialog above. Choose Centurion Online for Top Quality products from brand name manufacturers at competitive pricing

In order to continue with this guide, and continue the discussion on Binding a control to Microsoft Access Database: Press the Button below: