Microsoft Access Interview Questions

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...

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

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...

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

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...

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.

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...

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.

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

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

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

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...

Docmd.Docmd.OpenQuery "QueryName"

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

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

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

SELECT *
FROM Services
WHERE Price > @Price

Tools > StartUp > Application Title > Ok 

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.

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...

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...

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.

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...

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.

+ 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...

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.