Microsoft Access And Excel

Nairaland Forum | Technology | Programming | Microsoft Access And Excel

Pages: (1)

Author

Topic: Microsoft Access And Excel (Read 226 views)

casler

Microsoft Access And Excel

« on: April 15, 2008, 05:14 PM »

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

speakout

Re: Microsoft Access And Excel

« #1 on: April 17, 2008, 09:54 AM »

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.

uspry1 (f)

Re: Microsoft Access And Excel

« #2 on: April 17, 2008, 05:13 PM »

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:

userName	userCity
John Doe	Lagos
Mary Doe	Victoria Island
Joe Doe	Lagos
Helen John	Port Harcourt
Doe John	Ikeja
Bill Gates	Festac

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:

Employee Name	Monday	Tuesday	Wednesday	Thursday	Friday	Total Hours
John Doe	8	8	8	8	8	40
Mary Doe	4	4	4	4	4	20
Joe Doe	8	8	8	8	8	40
Helen John	4	4	4	4	4	20
Doe John	4	4	4	4	4	20
Bill Gates	4	4	4	4	4	20
Total	32	32	32	32	32	160

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

FMK (m)

Re: Microsoft Access And Excel

« #3 on: April 21, 2008, 06:18 PM »

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

sbucareer (m)

Re: Microsoft Access And Excel

« #4 on: April 25, 2008, 11:06 PM »

MS-Access and MS-Excel are both used for data storage, retrival and manipulation, hence both are used for database. The real difference is that MS-Access is a RDBMS and MS-Excel is NOT a RDBMS.

MS-Excel uses sheet to define its record, whilst MS-Access uses table to define its record. Access is mainly for handling raw or normalized data, whilst Excel is mainly use for data calculation.

However, it is possible to transfer data between excel and access with little or no headache

fellybabe (f)

Re: Microsoft Access And Excel

« #5 on: April 28, 2008, 07:54 PM »

nice hint

Dan Dare

Re: Microsoft Access And Excel

« #6 on: May 06, 2008, 11:49 PM »

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

Programmers Needed - Vb.net, Php, Javascript Javac Welcome1.java Could Not Compile The Application I Wrote,please Help. Gsm Programming Language Page 2

Pages: (1)