Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-21-2017, 06:23 AM
bcemail bcemail is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Mar 2014
Posts: 2
bcemail is on a distinguished road
Default Best Program for these Tasks?


I'm looking at a new position, and there are some goals that management has for the person chosen. They would like to create a tracking system for employee certifications, to include notifications for when certifications expire, test results, etc. I'm hoping to be able to help get this going, and provide some ideas.
I've seen some templates for doing this through Excel, which I am very comfortable with. But I was wondering, is this better handled through Access? I'm less experienced at creating an Access database, but certainly willing to learn/try.
We use SharePoint, so I'm guessing they will want it to be something that all employees who have certifications can access. How are notifications for something like this best handled? I've setup a group calendar in Outlook for basic notifications, but thought a calendar would be too limiting for something like this.

I'm sure this is something that many people have created in the past, so I don't want to re-invent the wheel. Just want to have some ideas if asked, to make myself more competitive. Thanks in advance for any help and advice!
Reply With Quote
  #2  
Old 07-23-2017, 12:13 PM
silentwolf silentwolf is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Dec 2016
Location: Austria
Posts: 15
silentwolf is on a distinguished road
Default

Hi,
I believe something like that is better in access then excel. But it is different to excel and need to have a good understanding of what you need and how to structure this database for all what you want.
To get started in access you first should write down what your goal ist and therefor you will find out what tables you need.
But be aware this can take up some time. Maybe someone here has a similar database already created and can give you an idea of what tables you should be thinking of creating.

Silentwolf
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 365 My Tasks: Tasks vs. TodoList--Sort? markg2 Outlook 0 04-17-2016 03:21 AM
updating not completed tasks or 0% tasks ketanco Project 3 08-24-2012 05:59 AM
Export Excel tasks into Outlook Tasks (2007 Version on both) crazedmom Excel 0 12-29-2011 07:55 AM
Not sure what program to use komobu Office 1 02-25-2011 04:14 PM
Don't know which program to use! Raner Office 3 12-09-2009 08:08 AM


All times are GMT -7. The time now is 07:04 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft