Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Creating Table in Access - Best Practices

Posted on 2014-04-15
7
Medium Priority
?
412 Views
Last Modified: 2014-04-15
Hello,

When I am creating tables to store data – for example product specific in a table – what are some good or best practices I need to do in the Field Properties > General for all the fields within a table?
Please suggest what best practices you have learnt from past experience.
0
Comment
Question by:Rayne
  • 4
  • 3
7 Comments
 

Author Comment

by:Rayne
ID: 40002429
0
 

Author Comment

by:Rayne
ID: 40002433
Settings some good to have field properties for maintaining the  data within the table in the long run
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40002465
1. Choose the appropriate data type.   ie. don't store a number in a text field.
2. Use the comment field to indicate what your using the field for.
3. Set the Caption field, even if it is the field name.
4. Make sure you set the required and allow zero length string as appropriate.
5. For field names, do not use any reserved character or word  ie. Desc is bad for a field name, because that is used for a descending sort.   'Date' is a function name in VBA.

Jim.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Rayne
ID: 40002518
Thank you Jim,

That’s a GOLD. One question>
3. Set the Caption field, even if it is the field name.
If I set up caption in the table and then create a form out of it, then will the form display that caption I originally set in the source table? Also why would need a caption?

Thank you
0
 
LVL 59
ID: 40002559
If you set the caption, it will be picked up when creating a control based on the field.

As for why, you might have a field such as SSNum, but want it displayed as Soc Sec #

# in a field name being bad because it's a date delimiter, so you don't want it there, but might for the caption.   Or "EmpID" might be "Emp ID" for the caption.

Jim.
0
 
LVL 59

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 40002566
Assuming by the way that you know that embedded spaces in field names and/or any special characters is not a good idea.

Jim.
0
 

Author Comment

by:Rayne
ID: 40002609
This is perfection to the ultimate, thank you :)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question