Microsoft Access Database Interview Preparation Guide
Download PDF

Microsoft Office Access Interview Questions and Answers will guide us now that MS Access previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. So learn Microsoft Access with Microsoft Office Access Interview Questions with Answers

26 Microsoft Access Questions and Answers:

1 :: What is the size limitation of an Access database?

Size limitation does not pertain to number of records in a table within a database. Forms, reports, macros, and modules also contribute to database size, but is rather minimal compared to tables containing records. It is recommended that if large amounts of data will be maintained or constantly deleted and new data imported, put your tables in another database and link the tables back into the main database. The utilities for database compression and repair will run much more quickly. In Access 2.0 databases the byte size limitation is 1 gigabyte. In general, use the 1gb rule and suggestions here to maintain performance of the database. See also "How Replication Increases Size of Database.".

2 :: How do you add a developer to a trusted publishers list?

Whenever a developer is signing into the code project you will have three options they are disable the macro, enable the macro and explicitly trusting the publisher. You can trust the publisher by allowing from the control panel of the windows. Always have an option left to enable or disable the macros because sensitive information regarding your code can be leaked out within fraction of seconds.

3 :: Would you like to easily automate your MS Access database through menu driven selections?

This can be accomplished by creating a form with customized buttons that point to macros. An easier way is to use MS Access' built in function called "Switchboard Manager". This can be located in Tools/Add-Ins.

4 :: Explain about managing data tasks?

Data can be managed by using the features of Import text wizard and export text wizard. Here you can save the operation for future use. First you should edit the specification name after clicking it you can make changes to the text box. Path can also be changed by clicking and modifying the changes in text box. Changes to the description of the file name can be made by making a change in the text box and then saving the changes to the path, specification name by pressing enter.

5 :: When I assigned a primary key to my table in Microsoft Access, I was expecting my data to be sorted. Am I using the correct procedure?

Some developers occasionally rely on indexes to sort their data, but shouldn't. That's because an index is an internal Jet operation that relies on internal rules to speed sorting, which is not the same as actually performing the sort. Records are not stored differently or changed. The sort is not performed until an action is being taken against the data like a query. This is not the same as simply opening a table in its Datasheet View. Although an index often appears to sort data, those internal rules often conflict with normal sorting practices and can have unexpected results. Sorting can be accomplished through the use of a query where ascending or descending can be specified against any one of the fields chosen from the table.

6 :: How do you import data from another access database?

The process of importing data from another Access database follows these general steps they are.
► Preparing the document for import operation and make sure that extensions are not in .mde or .accde because in that extension you can import only tables.
► Source should be closed automatically when the process is completed
► Make sure that you have permission for read and write.

7 :: I am using the Switchboard Manager in MS Access. I am getting an error message There was an error executing this command.

The Switchboard manager in MS Access offers only limited information on errors that occur within the database. Execute the selection directly from the database window to get more detailed information on the error.

8 :: What happens if the both source and destination are named the same?

The import operation present in MS Access does not overwrite or modify any of the existing tables or objects. If both the source and destination are the same it makes sure that numbers are appended to the name of the source file. For example a table having a name as info will be renamed as info1.

9 :: What format should my database be saved in to allow different versions of Microsoft Access to open the database?

MS Access is not backwards compatible. To share tables between different versions of MS Access, you can link the tables between two different databases. However, only the tables in the converted database would be available.