Category Archives: MS Access Interview Questions

Name at least six file extensions of Microsoft Access? | MS Access Questions

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

Posted in MS Access Interview Questions | Leave a comment

Explain about the protection features present in MS Access? | MS Access Questions

If a programmer doesn’t wish to make changes to the document he can lock the document data and its code from further changes by changing the extension of the file system to .MDE. Changes can be made only to the … Continue reading

Posted in MS Access Interview Questions | Leave a comment

State some of the uses of MS Access? | MS Access Questions

MS Access provides a huge range of functions some of them are: -It is used by small business, departments of large corporations, and by amateurs to create applications on their desktop for data applications. -Access is very useful for small … Continue reading

Posted in MS Access Interview Questions | Leave a comment

Explain about the various features present in MS Access? | MS Access Questions

Microsoft access has huge benefits for a programmer and end user. Some of the benefits are: -Relative compatibility with SQL and VBA. -Microsoft SQL server desktop engine is embedded into the Access suite along with Jetdata base engine which can … Continue reading

Posted in MS Access Interview Questions | Leave a comment

Explain about Microsoft access? | MS Access Questions

Microsoft access name has been changed to Microsoft office access. This software incorporates relational database management system which combines GUI (graphical user interface) with Microsoft Jet database engine. It can import and use data from Access, SQL, oracle, etc. This … Continue reading

Posted in MS Access Interview Questions | Leave a comment

Explain about creating a report tool by using the report tool and report wizard? | MS Access Questions

Report tool creates a report very fast because it will not ask you for much information for creating your report. it displays the entire field but it may not be the polished data source you are opting for. Report wizard … Continue reading

Posted in MS Access Interview Questions | Leave a comment

Explain the steps for this message could not delete from the specified tables? | MS Access Questions

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: I) Delete query should be opened and if it is not opening … Continue reading

Posted in MS Access Interview Questions | Leave a comment

Detail about how you can import a sharepoint list? | MS Access Questions

Importing a sharepoint list to an access database gives you a range of flexible convenient options first a copy is made into the access database after which you can specify the lists which you would like to copy. Also you … Continue reading

Posted in MS Access Interview Questions | Leave a comment

State some criteria s and their effects Of a database? | MS Access Questions

It is possible to enter one or more criteria in the rows which can affect your database significantly. >=“Callahan” this returns all the various records from Callahan to the end of the alphabet. Date() This field returns all the data … Continue reading

Posted in MS Access Interview Questions | Leave a comment

State some of the uses append query? | MS Access Questions

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 … Continue reading

Posted in MS Access Interview Questions | Leave a comment