Microsoft Access By Mandeep

Microsoft access

By mandeep

Ms access •

• •

Ms access is a microsoft tool for relational database management system. It combines microsoft jet database engine and gui. Microsoft jet database engine is based on database engine on which various microsoft products are based. Database engine is actually a underlying database and it contain the systematic information through which data is stored in computer. Visual basic and ms access use jet as underlying database engine. In microsoft access, we first have to create new project. In a new project, many options are there to create table, create queries etc.

•

In Microsoft Access, when you try to run an append query, to run a make-table query, or to import data in a large Microsoft Access database file, you may receive the following error message:

•

This problem occurs when the size of the Access database file approaches the 2 gigabyte (GB) size limitation

•

.

Excel can store only upto 65k records.