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

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

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

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

awantika

• Sep 4th, 2012

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

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

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

Though there are options to recover a deleted table, there is no option to get back records that are deleted directly from database tables.

Records once deleted from database tables cannot be undone.

Answer Question  Select Best Answer

Hello, I have imported log file into MS access with columns server,date,time,url.I need to write VB script in VB editor for accessing rows in between given date and time.It's urgent.please can any body help with this.Thanks

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

MS Access has built-in Visual Basic Module Editor, Click on Modules Tab Click New Create Public Function Put in your code Save, Close, Re-Open, Now you can use your VB Script anywhere in MS Access...

Answer Question  Select Best Answer

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

You can create a query using SUM function to calculate the sum of a column.

SELECT SUM([Column_Name]) FROM [Table_Name]

or

In reports You can place a field in footer with control source as "=SUM([Column_Name])" which will calculate the sum of the column.

Answer Question  Select Best Answer

Programmer

• Aug 31st, 2011

Validation in microsoft Access can be done using several properties:
1.data types
2.Required property
3.input mask property
4.Validation rule property
5.BeforeUpdate Event

Answer Question  Select Best Answer

Anil

• Aug 27th, 2011

Simple Query,
Cross Tab Query,
Find Duplicate Query and
Find Unmatched Query

Shyam Sansare

• Aug 5th, 2011

Select Query, Make Table Query, Append Query, Update Query, Crosstab Query & Delete Query

Answer Question  Select Best Answer

Mike Reveile

 Profile Answers by Mike Reveile Questions by Mike Reveile

• Mar 14th, 2011

SELECT [MSysObjects].[Name]FROM MSysObjectsWHERE ((([MSysObjects].[Flags])=0) And (([MSysObjects].[Type])=1));This should list all the tables available that are not hidden or system

Answer Question  Select Best Answer

I have data base tables in MS access.I want to migrate to Oracle.How can i?

gregharp

 Profile Answers by gregharp Questions by gregharp

• Mar 3rd, 2011

Oracle SQL Developer is a free and fully supported product that provides tools and utilities to migrate from Microsoft Access to Oracle. Whether you plan and complete the migration on your own or with...

Answer Question  Select Best Answer

How will you create a macro that can run action query?

raghshobha

 Profile Answers by raghshobha Questions by raghshobha

• Sep 26th, 2010

Docmd.Docmd.OpenQuery "QueryName"for action querys to avoid warning messages you can even try thisWith DoCmd      .SetWarnings False      .OpenQuery <queryname> End With 

Answer Question  Select Best Answer

yaugen

 Profile Answers by yaugen Questions by yaugen

• Apr 20th, 2010

You can specify parameters in a query using @, i.e.:SELECT *FROM ServicesWHERE Price > @Price

Answer Question  Select Best Answer

Harsha.Makhijani

 Profile Answers by Harsha.Makhijani Questions by Harsha.Makhijani

• Jul 13th, 2009

Tools > StartUp > Application Title > Ok 

Answer Question  Select Best Answer

gaur_dpak

 Profile Answers by gaur_dpak Questions by gaur_dpak

• Sep 27th, 2008

Go to the macro section of a database section. Choose OpenQuery from the drop down list. Further choose the Query name from the list below (of already made queries in the database). The run the macro. U will see the result.

Answer Question  Select Best Answer

saurav560

 Profile Answers by saurav560 Questions by saurav560

• Jul 26th, 2008

We building a Query and asking question to our database to get the answer. What Information we going to pull from the query? we added the query and then we check result we see a table is being create...

Answer Question  Select Best Answer

saurav560

 Profile Answers by saurav560 Questions by saurav560

• Jul 26th, 2008

When  you are creating relationship between two tables , for e.g. We have two table (1Receipt Line item) (2 Sales Receipt)  we join the field Receipt number from table (1Receipt Line ite...

shaifulc

 Profile Answers by shaifulc Questions by shaifulc

• Jun 13th, 2008

You must have a primary key in one table and foreign key in the other table.  You can then go to relationship view window.  Bring both tables in the grid.  connect both PK and FK.  dblclick on the connected line and set your ref integrity.

Answer Question  Select Best Answer