I want to learn Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am jai working as Juniour Executive in Human Resource department. My boss
has said to me that to make my work more efficient you should learn access. I
am quiet fluent in Ms-excel and Ms-word but I don't know anything about
access. Can anybody tell me that how can access is beneficial for me or what
can I do from access like we can perform any type of calculation with help of
formulas in excel and we can make any type of format in Ms-word?

Jai
 
jai said:
Hi,

I am jai working as Juniour Executive in Human Resource department. My
boss
has said to me that to make my work more efficient you should learn
access. I
am quiet fluent in Ms-excel and Ms-word but I don't know anything about
access. Can anybody tell me that how can access is beneficial for me or
what
can I do from access like we can perform any type of calculation with help
of
formulas in excel and we can make any type of format in Ms-word?

Jai
Click to expand...

Is it exam time again?

Your boss has made the decision that using Access will "make my work more
efficient", so ask him, he ought to know. For the record, Excel, Word and
Access are all different tools for different jobs, so it depends on what the
job is.

Keith.
 
If I were you, I would go to Microsoft.com and take a look at the online
tutorials for Access. They walk you through some of the basics. I'd also
find a book or two on access that will walk you through all of the features
at a comfortable pace.

You might also open the Northwind database that ships with Access and just
play around with it. Find out how it works. There are several other
"templates" on Microsoft.com that you could download and play around with.
When I built my first few databases, I started with those templates and
added on. Maybe download the contact management template and try to modify
the contact table to include data that is relevant to you. Then adjust the
forms, reports, and queries to match. Next, try to add a new table for
additional information, and a new report, etc.

As you start working, post back here if you run into specific questions and
we can help you out.
 
Once you have used Access you wonder how you got along without it!

I use Access in my business and I have 34 offices with over 20,000 clients.
Sure there are complicated ways to do things but the basics are very easy.

Assuming you’re really new to access it might help if you think of Access as
several excel spreadsheet that you can all join together so that when you
update information in one spreadsheet you update them in all of them. (That’s
not how it really works but it’s an easy way to think of it)

For instance you probably have a spreadsheet that lists all of your
employee’s names addresses and phone numbers. You also probably have another
spread sheet that again list your employee names and their review dates, and
maybe another spreadsheet that has the employee name and what benefits they
have. What happens when someone gets married? You need to update all of the
spreadsheets with the new name then don’t you? Access uses common variables
(called a Key) like an employee ID to keep all information organized. So
when you update the name on the one sheet with the name addressee ct, all the
other spreadsheets don’t need updating because they are related by the
employee ID.
With that being said, when you want to see the benefits of the person rather
than looking at a separate spreadsheets for information it is much easier to
say show me all records related to Employee ID xxx. All records can be
updated independently but still be related. It may sound complicated but you
can really have a good grip on how it works in a few hours if you quickly
read something like Access for Dummy’s or something. The biggest help in
learning is having a need, from there you just need to be creative and play
around a lot.

The basics that you need to remember are: Tables hold your data,(they look
like spreadsheets) Queries allow you to filter your data, Forms allow you to
make your data look pretty, and Reports are how you can print data that you
want

The best part of Access is that you can make forms that make data entry very
useful and earn if you have a purpose. One Form can be a combination of
tables so that with one click of your mouse you can see any information you
want, and its not in a crappy spreadsheet that you need to scroll up and down
on.

As you can tell I’m a believer, give it a try
 
Back
Top