Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

There are several methods in MS Access where the concept of triggers can be put to use From Tables, Forms, Reports You can create triggers at various levels and events. In fact MS Access makes this p...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

The following objects are present in MsysObjects table of Microsoft Access

Connect
Database
DateCreate
DateUpdate
Flags
ForeignName
Id
Lv
LvExtra
LvModule
LvProp
Name
Owner
ParentId
RmtInfoLong
RmtInfoShort
Type

Answer Question  Select Best Answer

awantika

• Sep 4th, 2012

Simply replace with a working Replica and delete the faulty or corrupt Design master

Answer Question  Select Best Answer

Explain with an example which situation that pivot tables can save time compared to any other reporting tools available

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

Using Pivot Table we can view data multidimensionally. It is basically used for improved presentation of data. A Pivot Table not only summarizes data by categories but also by subcategories. One of t...

Answer Question  Select Best Answer

anmol

• Feb 7th, 2014

Compact the database when it goes morethan 50MB by using compact and repair.

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

Few of the steps that can be taken to improve the performance of Microsoft Access Database are as follows: Plan and Design your tables appropriately as required. Create Normalized Tables. Do not cr...

Answer Question  Select Best Answer

linkplz.info

• Mar 27th, 2015

A super key is a list of columns to identify a unique row. A candidate key is a minimum set of columns required to identify a unique row from a table.

Answer Question  Select Best Answer

mani

• Jul 26th, 2017

How to insert image in MS-Access database using Java swing?

Mubashir Hameed Koul

• Jul 2nd, 2007

First thing we need to do is set the column type as OLE Object. While saving the data into the column of type OLE Object, save the data as byte array, while retrieving the image from the column read t...

Answer Question  Select Best Answer