-
Explain dynasets in MS Access
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...
-
MS Access International Characters
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.
chetannagar
- Mar 5th, 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.
-
How to migrate the MS access to Oracle?
I have data base tables in MS access.I want to migrate to Oracle.How can i?
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...
-
Run Action Query Using Macro
How will you create a macro that can run action query?
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
-
How to create pivot table ?
Explain with an example which situation that pivot tables can save time compared to any other reporting tools available
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...
-
-
What are the steps to be taken for improving performance in Microsoft Access database?
anmol
- Feb 7th, 2014
Compact the database when it goes morethan 50MB by using compact and repair.
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...
-
How to share a Microsoft Access database across a network?
johnjustin
- 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.
MaryLustion
- 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...
-
What are the steps for setting referential integrity between two tables present in the Microsoft Access database?
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
- 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 is an Index, Primary Key and Foreign Key? When do one use index?
vmshenoy
- Jan 6th, 2007
An index key orders one or more table columns (keys). It hasattributes such as being unique or primary, a comparison specification for textcolumns, and a list of columns which make up the key.
vmshenoy
- Jan 6th, 2007
Primary key is a candidate key (out of many candidate keys),that is chosen by DB designer to identify entities in entity set. Thatis it is used to identify rows uniquely.Foreign Key is a -column ...
Microsoft Access Interview Questions
Ans