Titles

[Guest]

When I have created the relevant sections and given them a title ie NAME,
ADDRESS etc, how do I view the screen where I am able to see those titles at
all times even though I'm way down the page (if you follow what I mean).

Thanks

 

[Guest]

If you're looking at a table or query view, scrolling down the screen will
still keep the titles at the top.

HOWEVER, ideally you should create a form or report to view your data, as
these are access' presentation layer. (This is where it can become more
complicated).

For simplicity, my rule of thumb is, if the database is for me, I'm happy to
look directly at the tables, 'cos I'm confident I won't knack my own data. If
it's for someone else, I create a form (use the forms wizard) to look at the
data.

Forms and reports can range from the fairly simple to very complex. However
even some complex forms can be generated easily using the forms wizards. Go
on, give the forms wizards a go... you might be surprised.

 

[Nikos Yannacopoulos]

Hey, this wouldn't be Excel you're asking about, would it?

 

[Marc]

When I have created the relevant sections and given them a title ie NAME,
ADDRESS etc, how do I view the screen where I am able to see those titles
at
all times even though I'm way down the page (if you follow what I mean).

Thanks

Put those fields in the form's header area. View -> Form header

HTH
Marc

 

[Guest]

Perhaps. I've been asked to create a database for someone who has initially
started it in excel. However, it needs to be more structured. I was toying
with the idea of perhaps carrying it on in excel (but need to see the titles
so I can follow what the first person has done). Alternatively, as I know
Access is a database package, type it up in that but again I would like to be
able to see my titles as I work.

 

[Nikos Yannacopoulos]

Apparently I wasn't very clear. What I meant was that the particular
question "how do I keep my titles visible" sounded like you were trying
to do this in Excel and had this problem.

To your original question: Excel is better for what it was designed, and
Access is better for what it was designed also! The fact that some
things can be done in either doesn't make them substitutes for one another.
By what you describe I suppose it can be done in Excel just fine, so I
wouldn't recommend Access if this is all you are ever going to need.
Access is a different animal with capabilities unimaginable in Excel
(but Excel wasn't made for that to begin with), the problem is you have
to learn a new tool, lots of new concepts etc. and it will take time.
This is why I wouldn't recommend it just for the purpose; if, on the
other hand, you think there is more you could do with Access in the
future, then you should probably consider investing the (considerable)
amount of time required.

HTH,
Nikos