Huge Spreadsheet

J

Jeff

I have inherited a HUGE spreadsheet that consists of 15 columns, and over
5000 records.

It is a list of employee reviews.

The Column Headings are: Employee name, Review date, Rating, comments, etc.
So one employee would have several "records" or rows, one for each review.
I would like to pull over records based on certain criteria, such as employee
name, date, etc.

Is this an application for ACCESS?

Thanks!!
 
H

Hasan Kocaman

Jeff said:
I have inherited a HUGE spreadsheet that consists of 15 columns, and over
5000 records.

It is a list of employee reviews.

The Column Headings are: Employee name, Review date, Rating, comments,
etc.
So one employee would have several "records" or rows, one for each review.
I would like to pull over records based on certain criteria, such as
employee
name, date, etc.

Is this an application for ACCESS?

Thanks!!
 
P

PvdG42

Jeff said:
I have inherited a HUGE spreadsheet that consists of 15 columns, and over
5000 records.

It is a list of employee reviews.

The Column Headings are: Employee name, Review date, Rating, comments,
etc.
So one employee would have several "records" or rows, one for each review.
I would like to pull over records based on certain criteria, such as
employee
name, date, etc.

Is this an application for ACCESS?

Thanks!!

To add a bit to previous answers, a simple design could be sufficient, given
what you've provided.
Consider an Employee table, with columns for data related to the employee
(including a unique identifier, or primary key, for each employee, such as
an employee number). A second table, Ratings, would have columns for data
for each rating and include a foreign key column to associate each rating
with an employee.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top