Microsoft Access Programmer San Francisco, California

The material below originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission. There may be references to "Figures" or "Chapters" that are not reprintable and are not used on this page.

Remember to call MS Access Solutions at (323) 285-0939 for your FREE consultation.

MicrosoftAccess Field Properties

In addition to field properties, you can specify properties that apply to a table as a whole. To access the table properties, click the Property Sheet button on the ribbon while in a table's Design view.

Access Database Description Property

The Description property is used mainly for documentation purposes. The Default View property designates the view in which the table appears when the user first opens it.

Microsoft Access Validation Rule Property

The Validation Rule property specifies validations that must occur at a record level, instead of a field level. For example, credit limits might differ depending on what state a customer is in. In that case, what's entered in one field depends on the value in another field. When you enter a table-level validation rule, it doesn't matter in what order the user enters the data. A table-level validation rule ensures that the proper dependency between fields is enforced. The validation rule might look something like this:

[State] In ("CA","NY") And [CreditLimit]
<=2500 Or
[State] In ("MA","AZ") And [CreditLimit]
<=3500 Or
[State] Not In ("CA", "NY", "MA", "AZ")

This validation rule requires a credit limit of $2,500 or less for applicants in California and New York and a limit of $3,500 or less for applicants in Massachusetts and Arizona, but it doesn't specify a credit limit for residents of any other states. Table-level validation rules can't be in conflict with field-level validation rules.

Validation Text Property

The Validation Text property determines the message that appears when the user violates the validation rule. If this property is left blank, a default message appears.

The Access Filter Property

You use the Filter property to indicate a subset of records that appear in a datasheet, form, or query. You use the Order By property to specify a default order for the records. The Filter and Order By properties aren't generally applied as properties of a table.

Access Subdatasheet Name Property

The Subdatasheet Name property identifies the name of a table used as a drill-down. If this property is set to Auto, the drill-down table is automatically detected based on relationships established in the database. The Link Child Fields and Link Master Fields properties are implemented to designate the fields that are used to link the current table with the table specified in the Subdatasheet Name property. These properties should be left blank when Auto is selected for the Subdatasheet Name. You use the Subdatasheet Height property to specify the maximum height of the subdatasheet and the Subdatasheet Expanded property to designate whether the subdatasheet is automatically displayed in an expanded state.

The Access Orientation Property

The Orientation property determines the layout direction for the table when it is displayed. The default setting for USA English is obviously Left-to-Right. This property is language-specific, and the Right-to-Left setting is available only if you are using a language version of Microsoft Access that supports right-to-left language displays. Arabic and Hebrew are examples of right-to-left languages. By installing the Microsoft Office Multilanguage Pack and the Microsoft Office Proofing Tools for a specific language, and by enabling the specific right-to-left language under the Microsoft Office Language Settings, you can also turn on right-to-left support.

---

Author Attribution

This material originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission.

---

Expert Microsoft Access Programmer In San Francisco, CA

When you need a Microsoft Access programmer for your San Francisco, California, business, agency, or organization, call MS Access Solutions at (323) 285-0939. We have over 25 years experience in Microsoft Access programming and application development. We create Access database applications for all industries, including (but not limited to):

• Medical Offices
• Hospitals
• Government Agencies at State, Federal, and Local Level
• The U.S. Military
• Small Colleges and Large Universities
• Agriculture and Horticulture
• Human Resources Departments and Employment Agencies
• Oil and Gas Companies
• Chiropractors
• Dentists
• Insurance Agencies
• Insurance Companies

We handle a wide range of Microsoft Access programming tasks, from advanced database architecture and SQL Server back-end design to smaller but still critical repairs. If your business relies on Access for daily operations, we're equipped to build or maintain custom systems that are stable, fast, and scalable.

For clients who just need help fixing things, we do that too. We routinely repair broken Access forms, update or rewrite MS Access reports, and troubleshoot issues in macros or VBA code. If a feature stops working or throws errors, we know how to find the problem and fix it without making things worse or rewriting your entire application.

We also help businesses who have outgrown their original database setup. Maybe the file is running slow, or too many users are connecting at once, or maybe you've hit the 2GB file size limit in Access. We can migrate your data to SQL Server while keeping the front end in Access so your staff doesn't have to relearn the software. That's often the best move for speed and stability.

In most cases, we're able to work directly with your existing files. No need to start over. We can review your current database, clean up any corruption, update tables, rebuild broken relationships, or rework modules written years ago. We also document the changes we make, so you or your IT person can understand what's been done.

Here's a short list of common Microsoft Access services we provide:

• Building new Microsoft Access front-end applications
• Fixing broken forms, queries, and reports
• Writing or cleaning up VBA code modules
• Converting legacy Access databases to new versions
• Connecting Access to SQL Server back-ends
• Recovering data from corrupted .mdb or .accdb files
• Adding new features to an existing database
• Helping teams share Access files across a network

Every business uses their database differently. That's why our support is flexible. We work on small one-hour fixes as well as large projects that span weeks, or ongoing management for your database. You won't get pushed into an expensive rebuild if it's not needed. We'll tell you what's broken, what can be fixed, and what's worth rebuilding only if it makes sense for the future of your workflow.

References

• Microsoft Access Developer Reference
• Microsoft Access Support
• SQL Server Documentation

---

Get more Microsoft Access programming information on the Microsoft Access Programmer San Jose, California web page.