MENU
Flipping Heck! Learning To Be Productive One Day At A Time

Modifying Tables On Microsoft Access

Modifying Tables On Microsoft Access

Modifying Tables On Microsoft Access

FlippingHeck.com Staff
  • Staff Twitter
  • Staff Facebook
  • Staff Pinterest
  • FlippingHeck.com

Microsoft Access is undoubtedly one of the most popular systems utilised by businesses all over the country. The database management program allows you to store and track pretty much any type of information. This can be anything from your contacts to your inventory to your business procedures.

There are lots of fantastic tools and features found in this programme. If you’re looking to set this up on Mac, you should look online for expert help. Don’t stop at Access, either. You can get the full package of Word programs or equivalent. Check out What is the alternative to Notepad++ for Mac? – Setapp as a prime example. Nonetheless, this blog post deals specifically with tables. After all, the input and analysis of data is something that tends to be consistent across all businesses.

Weekly Round-Up #168: How Shoppers Shop, Secure Your Facebook Account And Wine Is Good For You (Yeay!)
In this week's round-up we take a look at how your products (or websites) colours can make a difference to your sales, how to secure your Facebook account in the wake of this week's disturbing news and the fact that wine (in moderation) can have some great health benefits.

Nevertheless, it is very unlikely that you will enter a table and just leave it how it is. You will probably need to make some edits down the line. Whether this is the need to input new data or you wish to set a character limit; the options are endless. Luckily this is something that is easy to do.

Skillshare - From Proficient To Pro

Here are five of the most popular ways you can modify your table on this Microsoft program. These will come in extremely useful whenever you need to make edits. Follow the steps one by one and you should easily achieve your goal.

Add a new field

  • Open the table in question
  • Click ‘Click to Add’ (the next free header)
  • A drop down menu will appear, select the type of data you wish to enter i.e. currency
  • Type a name for your field and hit enter on the keyboard

Rearrange an existing field

  • With your mouse, hover over the field header’s bottom border you wish to move
  • The cursor will become an arrow with four sides
  • Click the field and drag it to a new location
  • Release your cursor

Change the data type for a current field

  • Select the field in question
  • Navigate to the ribbon and select the Fields tab
  • Select the Formatting group
  • Click the Data Type drop down menu
  • Pick the data type you require i.e. date / time

Create a validation rule

  • Select the field you want the validation rule to be added to
  • Head to the ribbon and select the Fields tab
  • Click Validation
  • After this you should select Field Validation Rule
  • You will see a dialog box appear, this should be labelled ‘Expression Builder’
  • Click the text box
  • Type in your validation rule
  • Click ok
  • Go back to the validation option in the fields tab
  • This time click the second option in the menu; field validation message
  • Another dialog box will appear entitled Enter Validation Message
  • Enter the phrase you would like to appear whenever someone attempts to break the rule you have just created
  • Click ok

Setting a character limit

  • Select the field
  • Head to the Table Tools tab
  • Click Fields tab
  • Navigate to the Properties group
  • There is a box next to the Field Size option, click on this
  • Enter the maximum number of characters you want to allow in this field i.e. 3
  • Finish off by saving

With these five options at your disposal you should easily be able to make any amendments you require and enhance the functionality of your table.

E-Commerce, Online Shop, Web, Template, Website
Web content creators are in a rush to get their content out there. According to Statista, Google currently has 86.86% of the search engine market. It's no surprise that as a content creator, you would want the most popular search engine to pick you. However, creating content is not easy....
Featured Image Source: Pixabay
Please Note: This post may contain affiliate links. By clicking on these links you will not be charged any extra for purchasing goods and services from our preferred partners however flippingheck.com may receive financial compensation which contributes to the running of the site. For more information please read our Advertising & Affiliate Disclosure Policy

Leave a Reply

Your email address will not be published. Required fields are marked *