Follow this blog:
RSS
Email Alert

Microsoft Office

Office challenge: How to use input values as default values in an Access form

Takeaway: This week, test your Access skills with this fairly common efficiency request from data input personnel.

Let’s suppose one of your users transfers data from paper forms, usually submitted in batches, into an Access database. That means a lot of the data - salesperson’s name, territory id, and so on - repeats across the entire batch of forms. These aren’t true default values, not in the traditional sense. However, the user would like to input them once, and have them remain the default value as he inputs a record for each form in the batch, as if they were true default values. Could you do this for your user?

Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.

Susan Harkins

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Susan Harkins

Susan Harkins
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
7
Comments

Join the conversation!

Follow via:
RSS
Email Alert