From the course: Access Quick Tips
Join today to access over 22,700 courses taught by industry experts.
Effective naming conventions - Microsoft Access Tutorial
From the course: Access Quick Tips
Effective naming conventions
- [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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.