| |
111. What Command Is Used To Create A Table By Copying The Structure Of Another Table?
Date Posted: 07/03/2012
Ans: CREATE TABLE .. AS SELECT command
Explanation:
To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the following.
CREATE TABLE NEWTABLE AS SELECT * FROM EXISTINGTABLE WHERE 1=2;
If the WHERE condition is true, then all the rows or rows satisfying the condition will be copied to the new table.
|
| |
| |
112. TRUNCATE TABLE EMP; DELETE FROM EMP; Will The Outputs Of The Above Two Commands Differ?
Date Posted: 07/03/2012
Ans: Both will result in deleting all the rows in the table EMP.
|
| |
| |
113. What Are The Wildcards Used For Pattern Matching?
Date Posted: 07/03/2012
Ans: For single character substitution and % for multi-character substitution.
|
| |
| |
114. State Some Of The Uses Append Query?
Date Posted: 07/03/2012
Ans: Some of the uses of append query are as follows
► you will save time by appending data to an existing table rather than manual update.
► Appending files based on specific criteria is possible.
► If your destination file doesn’t have columns and rows you can add certain columns and rows thus ignoring the rest of them.
► Append can save time and labor when dealing with large database updation.
|
| |
| |
115. How Do You Create An Append Query?
Date Posted: 07/03/2012
Ans: Append query can be used if you would like to add new rows of data to an already existing table. The process of creating an append query follows these steps they are.
► Basic step should be to create a select query
► After selecting the query you need to append the query
► Destination fields should be selected for each column in the query
► Records can be appended by using the function to run.
|
| |
| |
116. Explain About Relationships And Look Up Fields?
Date Posted: 07/03/2012
Ans: Relationships are imported from the source to destination without any hindrance but once they land in the destination they can never be altered or changed and change of extensions cannot be of much help.
Lookup fields: -Make sure that you link tables, links, etc if you want to display look up values and not look up ids. Related table should be linked to the destination field for display of lookup values.
|
| |
| |
117. How Can I Open An MS Access Database That Has Been Converted To A Current Version?
Date Posted: 07/03/2012
Ans: MS Access is not backwards compatible. A workaround to share tables between different versions of MS Access would be to link the tables between two different databases. All objects in the database would not be available.
|
| |
| |
118. In MS Access, The Long And Short Date Option Does Not Show 4 Digit Years. How Do I Achieve The Mm/dd/yyyy Format?
Date Posted: 07/03/2012
Ans: In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.
|
| |
| |
119. Name At Least Six File Extensions Of Microsoft Access?
Date Posted: 07/03/2012
Ans: Some of the file extensions present in MS Access are
► Access blank project template .adn
► Access database .accdb
► Access project .adp
► Access Workgroup .mdw
► Protected access database .accde
► Access workgroup .mdw
|
| |
| |
120. Explain The Steps For This Message Could Not Delete From The Specified Tables?
Date Posted: 07/03/2012
Ans: This error is caused by delete query and when the unique property is set to no.
Following are the steps which should be taken to solve the problem.
1) Delete query should be opened and if it is not opening then press F4
2) Clicking the query properties underneath the query designer will give you options.
3) In that options you need to locate unique records property and should set it to yes. These options are present in query property sheet.
|
| |
