Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-21-2017, 06:23 AM
bcemail bcemail is offline Best Program for these Tasks? Windows 7 32bit Best Program for these Tasks? Office 2013
Best Program for these Tasks?
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
Old 07-23-2017, 12:13 PM
silentwolf silentwolf is offline Best Program for these Tasks? Windows 7 64bit Best Program for these Tasks? Office 2010 64bit
Join Date: Dec 2016
Location: Austria
Posts: 16
silentwolf is on a distinguished road

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.

Reply With Quote

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
Best Program for these Tasks? Not sure what program to use komobu Office 1 02-25-2011 04:14 PM
Best Program for these Tasks? Don't know which program to use! Raner Office 3 12-09-2009 08:08 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 11:03 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft