Microsoft Access Developer

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.

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

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

Finding records that match criteria is a common database function. To accomplish this specific query you can use the Not operator. For instance, if you want to find all your customers outside California, you might use the expression Not "CA" as your criterion.

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

Link the database to MS Word and create the labels. A DDE link is established within MS Word and a copy of MS Access actually launches with the database open. MS Word can then link directly to the table or query that the labels are being generating from.

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.

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.

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.

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.

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.

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.

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!

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.