From the course: Access 2007: Shortcuts

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Setting default appearance for new databases

Setting default appearance for new databases - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

Setting default appearance for new databases

If you customize most of your Database Tables with the same formatting, you can set Access's options, so that many of these preferences are set by default. I'll go up to the Office button and I'll make a new Database. On the bottom right-hand side I'll set the name to defaults and click Create. Now let's go take a look at Access's options. Go up to the Office button, and down at the bottom, choose Access Options. Go down to the Datasheet button and now we can customize the way your datasheet tables look in Access. Now, for the sake of this demonstration, I am going to make these look a little bit extreme, so that you can see the differences. In a regular database, they would be much more subtle. I can change my Font color. I'll make it Dark Blue. The Background color is the main color of the rows, and I'll go ahead and I'll make that Light Blue. For my alternating rows, I'll choose Light Green. I'll make my Gridlines lines Orange. Now by default, your tables have Horizontal and…

Contents