ACCESS - Faculty Database

  • Thread starter Thread starter Kris
  • Start date Start date
K

Kris

Couple of issues - 1) When creating a new field in design view, I can't
figure out how to keep the information specific to one person. It shows up on
everyone's. 2) When creating a new page in faculty details with new fields,
the field shows up on all pages. Took the tutorial, but didn't cover any of
this.
 
It sounds like you are trying to use Access the same way you would use Excel
as a spreadsheet. That is the wrong way to use a relational database.

Post what you are trying to do and possibly someone can suggest how to use
Access properly.
 
I used the faculty database for my educational employees. Some of the fields
did not apply and some of these I could modify to meet my needs. In another
case, I needed a specific field to reflect a particular data. I went to the
table and created a column. I then applied this new column with the button
"add existing fields". I ran into some serious problems with 1) the
information would distribute to each faculty member when what I needed was
the information to be specific to the individual. Problem 2 is that I needed
a new page when in design mode of the "faculty details". I right clicked and
added a new page (3). When I went to add an 'existing field' the field was
embedded on page 1 and 2. So I decided to just add a text box on page 3. When
I put in some trial data, it distributed to all other faculty members.
 
Your problem 1 - What was the datatype? Did it have a default?

Your problem 2 - You have be sure you on the Tab (page) and not the main
form. If on the main form it will appear on all Tabs.

Your problem 2 - Same questions are 1.
 
Couple of issues - 1) When creating a new field in design view, I can't
figure out how to keep the information specific to one person. It shows up on
everyone's. 2) When creating a new page in faculty details with new fields,
the field shows up on all pages. Took the tutorial, but didn't cover any of
this.
Click to expand...

Don't confuse data STORAGE with data PRESENTATION. They are very different
tasks!

A Table has the same fields for all records. You cannot add a field to some
records, and not to others. You can leave the field NULL (empty) in some
records, but the field will be there.

It's also possible that you are designing your database starting with your
Forms. That's a bit like building a house, and pouring the foundation when
you're halfway done. The tables, and their relationships, are *absolutely
fundamental* and must be done first; only then would you start adding controls
(not fields) to a form or to a tab control.

What are your tables? What fields to they contain? How are they related? What
"design view" are you talking about: table design or form design?
 
Back
Top