GeekInterview.com
Series: Subject: Topic:

Microsoft Access Interview Questions

Showing Questions 1 - 20 of 30 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

How to create pivot table ?

Asked By: sachinvinaya | Asked On: Jul 19th, 2011

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

Answered by: Lokesh M on: 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...

What are the steps to be taken for repairing a corrupted design master?

Asked By: janelyn | Asked On: Mar 9th, 2007

Answered by: awantika on: Sep 4th, 2012

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

What are the steps to be taken for improving performance in Microsoft access database?

Asked By: Remasri | Asked On: Mar 9th, 2007

Answered by: Lokesh M on: 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...

What are the objects present in the table msysobjects of Microsoft access database?

Asked By: joel | Asked On: Mar 9th, 2007

Answered by: Lokesh M on: 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

How can one implement the concept of triggers in Microsoft access database?

Asked By: sripri | Asked On: Mar 9th, 2007

Answered by: Lokesh M on: 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...

How can one get the deleted records in Microsoft access database?

Asked By: scott | Asked On: Mar 9th, 2007

Answered by: Lokesh M on: 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.

How to write script using database

Asked By: sappi_01 | Asked On: Dec 11th, 2007

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

Answered by: Lokesh M on: 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...

What is the way for summing up a column in a table in Microsoft access database?

Asked By: scott | Asked On: Mar 9th, 2007

Answered by: Lokesh M on: 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.

What are the query types available in Microsoft access database?

Asked By: nancyphilips | Asked On: Mar 9th, 2007

Answered by: Anil on: Aug 27th, 2011

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

Answered by: Shyam Sansare on: Aug 5th, 2011

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

What is the way for finding out whether a table exists in the Microsoft access database?

Asked By: RyanJames | Asked On: Mar 9th, 2007

Answered by: Mike Reveile on: Mar 14th, 2011

SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE ((([MSysObjects].[Flags])=0) And (([MSysObjects].[Type])=1));


This should list all the tables available that are not hidden or system

How to migrate the ms access to Oracle?

Asked By: anil.krotha | Asked On: Feb 20th, 2008

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

Answered by: gregharp on: 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...

Run action query using macro

Asked By: Awahab595 | Asked On: Nov 15th, 2009

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

Answered by: raghshobha on: Sep 26th, 2010

Docmd.Docmd.OpenQuery "QueryName"

for action querys to avoid warning messages you can even try this

With DoCmd
     
.SetWarnings False
     
.OpenQuery <queryname>
End With 

How can parameters be added to a query in Microsoft access database?

Asked By: christia | Asked On: Mar 9th, 2007

Answered by: yaugen on: Apr 20th, 2010

You can specify parameters in a query using @, i.e.:

SELECT *
FROM Services
WHERE Price > @Price

What are the steps to be taken for changing the title of the Microsoft access title bar?

Asked By: fred | Asked On: Mar 9th, 2007

Answered by: Harsha.Makhijani on: Jul 13th, 2009

Tools > StartUp > Application Title > Ok 

How to run a query using macro in Microsoft access database?

Asked By: StephenRaj | Asked On: Mar 9th, 2007

Answered by: gaur_dpak on: 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.

Explain dynasets in ms access

Asked By: prem singh | Asked On: Oct 29th, 2007

Answered by: saurav560 on: 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...

What are the steps for setting referential integrity between two tables present in the Microsoft access database?

Asked By: blenda | Asked On: Mar 9th, 2007

Answered by: saurav560 on: 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...

Answered by: shaifulc on: 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.

What are the ways to ways to run queries in Microsoft access database?

Asked By: christia | Asked On: Mar 9th, 2007

Answered by: dileepdon on: Jun 21st, 2008

Hi Christia,You can run a query in somany ways.Please find the below mentioned procedure to run a query...Flow 1: Click on View tab--> select Database Objects-->select Queries option--> click...

How to share a Microsoft access database across a network?

Asked By: Bessie | Asked On: Mar 9th, 2007

Answered by: johnjustin on: Apr 14th, 2008

Place the database in a computer which is connected in a network. Place the front end application in all the computers connected in the same network. Modify yor code in such a way that the applicaiton is accessing data from that computer where the database is available.

Answered by: MaryLustion on: Apr 10th, 2008

+ Its recommended to split the database in Frontend and backend. + Put the backend on a server/common computer.+ Give appropriate permissions on the folder for all the users who would be using that da...

Ms access international characters

Asked By: shashibsaini | Asked On: Nov 28th, 2007

I am using ms access as backed to store data having hindi fonts. My problem is I want to sort records according to hindi alphabets.

Answered by: chetannagar on: Mar 4th, 2008

To sort on international characters you use unicode coversion. first convert the character to equivalent unicode value and then you can sort it in number order.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.