can anyone tell me what Microsoft access do?

Question

can anyone tell me what microsoft access do? and like provide a picture of its work place withe lables?(it can be links )

thanks

Answer 1

It is easier to tell you what Microsoft Access Can't do. It cannot FRY CHICKEN.

Microsoft Access is a terrific desktop and local area network database. It easily connects with many other applications, so it can become a major communication and information center for your business or home. Mailing labels, mail merge and e-mail merge, documenter. It is just plain awesome.

It's only negative issue is that it is a bit on the slow side. Few use it on websites (even thought it would work).

But if you are looking for a chicken fryer, try eBay.

Good luck and Happy Computing!

Answer 2

A flat table contains information that is duplicated many times.
Like selling a car at a dealership the bussiness would keep a list of every vehicle sold and who sold it. The salesman name and his phone number would appear many times in the table(once for every car he sold) . The dealer would also want info on the saleman like home address and tax ID number ect. There would be no need to have this information in an inventory table.

Relational databases allow sharing of information between tables by referencing a unique key from one table in another



Access can organize groups of related data in tables. For example you can have a list of car salesmen at an auto dealer listed in an employee table. This table would contain allsorts of related data to each employee like home address, full name TaxID number ect...

The same dealrship would also have a detailed list of cars in their inventory. Again with related data such as make, model, year, new or used ect.

The power access has is that it is a relational database system. You can link the above tow tables together and relate specific information like what salesman sold which car by including the salesmans employeeID number in a field in the inventory database.

This means that employee information is entered once in the employee table but may be used many times in the inventory table simply by using a single employee number as to who sold the car.

A query may then be run listing car information and then linking in to the employee table and getting specific information like name and work phone number from teh employee table.


If teh employee gets a new phone number you would just have to change a single record in the employee table rather than having to change information in every single inventory record for every car he sold.

Answer 3

Microsoft get right of entry to is a Database administration equipment, this is a gadget to create relational Databases, so as to shop concepts, replace and delete concepts in an based format. it fairly is appropriate to study relational database theory, sq. bases, Database administration bases.

Answer 4

Extensive flat file database.
You can enter data and manipulate it in a way you wish. Its very robust flexible and useful, however it can sometimes be a bit daunting to learn.

Fairly wide list of ACCESS info:
http://www.improveyouraccess.com/access/access_training.cfm