Store Multiple Sex & Gender Options in Microsoft Access

In this Microsoft Access tutorial, we will learn how to store multiple options for sex and gender inclusively in your database. We'll discuss the importance of not using free-form text fields and how to create structured lists with an other option for additional flexibility.

Monica from Brookfield, Wisconsin (a Platinum Member) asks: Our office is making an attempt to be more inclusive, so management wants to start tracking our employees and customers by gender, and allow for a variety of responses such as male, female, non-binary, and so on. How do I go about storing this in my database? Do I just make it a text field now?

Prerequisites

• Relationships
• Relational Combo

Links

• Triple State
• Helper Data
• Anchor Items On Top
• List Items Edit Form

Recommended Courses

• Access Expert 1

Up Next

• Sex & Gender, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, inclusive database design, storing gender options, Access gender options, multiple gender values, gender identity database, non-binary data storage, inclusive employee tracking, sex and gender fields, gender combo box, customize gender options, Access table design gender, other gender option, relational combo box Access, employee gender tracking, customer gender tracking