Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you customize most of your database tables with alternative formatting you can set Access' options so many of these preferences are set by default. Let's start by opening up a new blank database. I'll go to the File tab and down to New. I'll change by Database name to the defaults and press Create. Let's go set Access' options. Go back to the red File tab and then go down to the bottom and choose Options. Go to the third button down for Datasheet.
Here we can set our default Gridlines. Tables by default have both Horizontal and Vertical Gridlines. I am going to go ahead and uncheck Vertical, so that all I have are lines going across. The Default cell effect is Flat, but you could also do a Raised and Sunken. Now be aware that Raised and Sunken will actually do away with the horizontal and vertical lines. Every cell is going to have that effect applied. I'll go ahead and make this Raised. By default, every Table has a 1 inch Column, but if I'd like that to be a little larger I'll change that to 1.5.
The Default font is set to size 11. I'll go ahead and increase that to 12. I can choose different font Weights as well; make them lighter or darker. You could also set the Default font to be Underlined or Italicized. I'll go ahead and make everything Italicized. Now I'll click OK. I am going to close this Table and don't save it. And I am going to go up to the Create ribbon and create a new Table. This will have all my new effects. My font size is a little larger and a little darker and my cells have a very subtle Raised effect to them.
Now do be aware that by changing these settings all the new Tables you'll create will share the formatting so that you won't have to set each one up separately, but this will also carry over to all new databases as well. When you want your databases to go back to the default, you'll need to go back to File and to the Options and reset them again.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74154 Viewers
80 Video lessons · 129550 Viewers
52 Video lessons · 63843 Viewers
59 Video lessons · 49621 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.