Microsoft Access Developer Interview Questions & Answers

Download PDF

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 allows you to create a table by giving you options on what to appear and what not to appear You can specify the relations, grouping and sorting between the tables.

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.

To find records, perform math calculations, (the total for a certain dollar figure based on a complex criteria for example), etc. In other words, it represents all the data your form has access to in your code.

This error has occurred in some labs at DMU Leicester, when students are trying to use the Documenter.

It probably means that the Access installation is incorrect.

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 have an option to copy an entire list or only a specific file. Also import operation creates a table in access which copies the entire fields and records specified into the Access.

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 file with an extension MDE. Tools are available in the market which can unlock and decompile the code but some changes to VBA or VB scripts are irreversible.

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.

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.

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 web based database applications hosted on IIS and using ASP.NET pages.
☛ It can be used as a RAD for building prototype and Stand alone applications.
☛ Access can be used as a frontend while the backend can be a ODI3C compliant product.

False, it only represents open forms in the database. If you have 20 forms in your database and only 3 are open, the expression Forms.Count will return only 3.

The following criteria should be met by the publisher before adding him to the list.
☛ The code project should have a digital signature of the publisher
☛ A valid digital signature should be in place
☛ Valid digital signature should not be expired
☛ Digital certificate which comes with digital signature should meet industry standards and specifications.
☛ Developer who is holding and signing the code project should be a trusted publisher.

To search for records. This is a trick question since I only know of one use of this property.

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.

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 software is used to build application software.

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

False, unlike the Forms collection, the table collection represents all tables, regardless of whether they are open or not. (The reverse of the form collection).

Access has many date manipulation functions - see Help for a full list.

Example - add 1 year to the system date:
=Date() uses the Date function and will give today's date (the system date).

=DateAdd ("yyyy",1, Date()) uses the DateAdd function to add one year to today's date.

You cannot reference another field in an expression like this in a table definition. But you could do so in VBA code for a data entry form, or in a calculated field in a query, for example.

=Date() + 365 will give a date in a year's time, but will not work for leap years!

For whatever you wish, it’s a property you can assign any string value. I love using it to identify controls only a certain role can see on the form, so I’ll assign Admin to the tag or purchasing or 1, whatever I wish.

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.

☛ Delete query should be opened and if it is not opening then press F4
☛ Clicking the query properties underneath the query designer will give you options.
☛ In that options you need to locate unique records property and should set it to yes. These options are present in query property sheet.

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.

By default, Access waits until you press Enter before it selects the Next control on your form. However, this is a wasted keystroke you can eliminate by setting each control's Auto Tab property to Yes. This Property also requires that you set an input mask. Once the data you're entering satisfies the input mask, the Auto Tab property Automatically selects the form's next control. We don't recommend you Use this feature unless you can apply it consistently; otherwise you'll just confuse your users, who won't know when to press Enter.

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.

SQL property. If you declare a qdf variable and assign it to a query, you can change the syntax of the sql statement using qdf.sql = “Select…”. One interesting feature of this property: You don’t have to save the changes, they are immediately saved. Compare that with the DAO recordset object where you must use the Edit method followed by Update in order to save your changes.

1 Gigabyte

Access interprets years differently than in prior versions. For example #01/01/15# returns January 1, 1915 in previous versions. Access will return January 1, 2015. Modify your date specification to be #01/01/1915#.