Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Data Models

Probably the hardest part of designing a database is constructing normalized tables. Get them wrong and everything else is down hill… you can’t get the Forms to do what you want and the Reports just don’t work. Let’s see if any of these can make your job easier…

Clubs (or Associations)

Complaints

DVD’s

Grocery List […]

 592 total views

Field Names in ALL CAPS

There will be times when inherit a database and the Field Names are all in capital letters. You want to convert them to CamelCase but when you try they revert back to all capital letters. Here are two different ways to handle that…1. a. Change the Field Name by adding a letter to the end […]

 547 total views