Huge Spreadsheet

[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!!

 

[Hasan Kocaman]

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!!

 

[Duane Hookom]

Access could handle this quite effectively.

 

[PvdG42]

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.

 

[Duane Hookom]

To add a little more, I would consider further normalizing your "spreadsheet"
so that each rating doesn't have its own column. There is a sample employee
evaluation MDB available at
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4&SID=ce9a4bzabf723zza64338e8ze79a949f