pls guys can someone put me through in the difference between microsoftexcel and microsoftacess

Microsoft Access is a database application strictly meant for managing data from beginning to an advanced level (programming in macros) while Microsoft Exell is a spredsheet application that took the place of lotus 1-2-3 and handles all data calculations. If unsatisfied, please contact me on maitanmi@yahoo.com for further trainings.

Give you few examples of using MS ACCESS and MS EXCEL.

For MS ACCESS

You create the database table as follow below:

userID
userName
userAddress
userCity
userCountry
userAge

Then insert all data on the following blank fields of those database table. Suppose your boss asks you the lists of username that live in a city to be reported. You use SELECT query on the database to pull only userName and userCity to display information the boss wants.

The database report will show ALL of userName with userCity like this below:
[table]
[tr][td]userName  [/td] [td]userCity[/td][/tr]
[tr][td]John Doe[/td] [td] Lagos[/td][/tr]
[tr][td]Mary Doe[/td] [td]Victoria Island[/td][/tr]
[tr][td]Joe Doe[/td] [td]Lagos[/td][/tr]
[tr][td]Helen John[/td][td]Port Harcourt[/td][/tr]
[tr][td]Doe John[/td] [td]Ikeja[/td][/tr]
[tr][td]Bill Gates[/td] [td]Festac[/td][/tr]
[/table]

Normally if you have more than 50-10,000 userNames to sort all userCity, that is what MS ACCESS for!

For MS EXCEL

You create your spreadsheet on worksheet to calculate the timesheet report using FORUMLA function like this:

[table]
[tr] [td]Employee Name  [/td] [td]Monday[/td][td]Tuesday[/td] [td]Wednesday[/td][td]Thursday[/td] [td]Friday[/td][td]Total Hours [/td] [/tr]
[tr][td]John Doe[/td] [td]8[/td][td]8[/td] [td]8[/td][td]8[/td] [td]8[/td][td]40[/td] [/tr]
[tr][td]Mary Doe[/td] [td]4[/td][td]4[/td] [td]4[/td][td]4[/td] [td]4[/td][td]20[/td] [/tr]
[tr][td]Joe Doe[/td] [td]8[/td][td]8[/td] [td]8[/td][td]8[/td] [td]8[/td][td]40[/td] [/tr]
[tr][td]Helen John[/td] [td]4[/td][td]4[/td] [td]4[/td][td]4[/td] [td]4[/td][td]20[/td] [/tr]
[tr][td]Doe John[/td][td]4[/td][td]4[/td] [td]4[/td][td]4[/td] [td]4[/td][td]20[/td] [/tr]
[tr][td]Bill Gates[/td][td]4[/td][td]4[/td] [td]4[/td][td]4[/td] [td]4[/td][td]20[/td] [/tr]
[tr][td]Total [/td] [td]32[/td][td]32[/td] [td]32[/td][td]32[/td] [td]32[/td][td]160[/td] [/tr][/table]
Total Employees:      6     Grand Total hours: 160

MS Excel calculates the total automatically for you in order to print it out giving to your supervisor who authorizes the payroll system based on employee's timesheet record.

Normally if you have more than 50-10,000 employees to calculate their timesheet automatically at the end of the day before the paycheck due, that is what MS EXCEL for!!!

guys,
becarefull  when explaining  about  Micro Acess  to create  Aplication.  we have simple and Advanced    according to information you need for your business Manegement

a simple  table and programe  in access everyone can do but when talking about  Application for business Management  you need to have very deep notion first in software programation  and  have advanced notion  in certain Area.  e.g  if i need an Aplication for  comercial Business   firstly make sure you  are experienced  in Economy, Analityc and  Account  Management,  if you need for bank job you need to understand bank operations 

programing Using Access you need to know what you need and list them but note that this needs deep reflect 

you need to create controls sources

QueriesReports
Micros
Combination Boxes
Automatics Boxes
Calculations cells
Designing formular
security system (data base security system  Access ID and Password
Out Put and Input  system
display boxes
data transference  from application to another apllication
They are a lot  a lot

Excell  and word are sheets  simple datas or report and also auxiliarry programes for  Applications or data base   in excell you can create a sheet for your payment and recording datas and calculation  but this is not suffecient for a business of million of dollars.  excell and word  help to down load report from Aplication  eg if my Aplication is not connected to internet  and i need to send a report that is in my Apliction  to my Boss is abroad, i need to down load this report to excell or word  then i can send it 

you can learn programing Aplication  but your personal wisdom is the key 

I have  experiance in this Area

nice hint

does anyone have any ebooks on these softwares or any links to learning material?