Laurie Ulrich explains effective naming conventions, and shows you that words matter—and using the right ones in the right way to name your fields can make or break the efficiency of your database.
- [Instructor] It might seem like a small thing,…but the names you give your fields really do matter.…To make it easier to navigate your database…and to export your data,…make all of your field names one word,…even if they're really made up of two or more words.…For example, here in my Students table,…first name is two words.…But I've got it as a single string.…If you want the look of two words,…separate them with an underscore character.…You can set these up quickly in Design View for each table.…
Notice that all my field names are in initial caps.…Why?…So you can quickly insert spaces in the field labels…on forms and reports.…Oh, and another tip while I'm at it.…While you're in Design View,…it's a good idea to tack the table name…onto your ID fields, so you can tell the ID field…from one table from the ID field in another.…
Author
Laurie Ann Ulrich
Released
2/27/2019- Planning your database
- Building tables
- Setting field properties
- Creating relationships
- Creating forms for data entry
- Finding data with queries
- Updating records with queries
- Building better reports
Skill Level Intermediate
Duration
Views
-
Introduction
-
1. Planning
-
Storyboarding1m 6s
-
-
2. Building a Table
-
3. Field Properties
-
Using input masks1m 19s
-
-
4. Relationships
-
Editing relationships1m 4s
-
5. Data Entry
-
Fast forms with subforms1m 12s
-
Create combo and list boxes1m 27s
-
Adjusting tab order in forms1m 15s
-
-
6. Queries
-
Finding missing data1m 7s
-
7. Reports
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Effective naming conventions