To combine text in Access, there is no Concatenate function, like there is in Excel. You must use the & symbol, instead. The formula would be written as such: =[City]&”, “&[State]&” “&[Zip Code] The results of this example would calculate
Access: Combine Text Read Post »
When using Excel, is there information that you are constantly scrolling to find? Use “Groups” to bring the information to you.Drag-select the columns (or rows) that you wish to groupThen click the Group command in the Outline group of the
Use “Groups” to bring the information to you – Excel Read Post »
Professional Development can incorporate a wide range of courses, from management to communication. However, one thing is consistent in professional development training: Every profession can benefit from them. Could you improve your time management to get more accomplished each day?
Professional Development Read Post »
One SharePoint feature allows a user to follow a document or site, or be notified when it has been modified.To set this up, you simply select the document you wish to follow, then click the Follow option in the Document
Following a document or site in SharePoint Read Post »
You can Auto Archive folders in Outlook, in order to keep excess emails from becoming an issue. Click on the Auto Archive command, under the Folder tab, in the Properties group. A dialog box appears that allows you to set
Outlook: Auto Archive folders Read Post »
Insert videos into your Word document by selecting the Insert tab, and clicking the Online Video command in the Media group. This will open a dialog box that helps you load the video. Search for videos by entering keywords in
Word: Insert Videos Read Post »
Subtracting dates can be easy. However, formatting the answer to be shown as a countdown to an event is a little tricky. But we can create a countdown timer in Excel to do just that: First, let’s subtract our dates,
Creating a countdown for two dates – Excel Read Post »
We recently completed a SharePoint project for a small business in Denver called Pillar Properties. The project went very well, and we wanted to create a case study to show off the work. The company needed to solve collaboration and
Small Business SharePoint Case Study Read Post »
We’re pleased to announce the creation of our new SharePoint Business Consulting Website. It offers information on our SharePoint consulting services and blog articles on everything SharePoint.We just posted the first in a series of articles on SharePoint Calendars.As always,
New SharePoint Site Announcement Read Post »
When SharePoint is well-designed and solves real business problems, a company will enthusiastically embrace the program and see all of the promised productivity gains. Unfortunately, not every implementation has the right measure of each critical ingredient to be successful. IT
Retargeting SharePoint Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
