ResearchTutorials.com

Make Access combo boxes drop down automatically

By default, in order to see the items in a combo box, you need to click on the little arrow in the drop down box. This can get tedious, especially if there are a lot of combo boxes on your form. It's also not efficient for high speed data entry, like using TAB to move through controls and the number pad or arrow keys to select answers. With just a few lines of code, you can make your combo boxes drop down automatically when the cursor enters them. I'll show you two ways to accomplish this.

Continue reading...

Create a Survey Database in Access: Part I

Microsoft Access is an excellent tool to assist with data entry for a survey project. With Access, you can create a simple data entry interface that not only looks like your survey, but also includes features to reduce data entry errors and still make the process go fast. This is part one of a two part tutorial spanning 16 videos which walks you through every step involved in creating a typical database for storing survey or questionnaire data.

Continue reading...

Create a Survey Database in Access: Part II

This is Part II of a two-part tutorial on how to create a survey database in Access. Part I introduced the sample project, survey, and how to set up the tables. Part II picks up where Part I left off, and walks you through how to set up your data entry form.

Continue reading...

Send Emails and Attachments from Access

If you have an Access database with a list of contacts and emails, watch this tutorial to learn how to add a form so you can email them and (optionally) include an attachment.

Continue reading...

Export Data from a Word Form to Excel

Do you have some completed Word forms and need to export the data to an Excel spreadsheet? Here’s how!

Continue reading...