June 2011
Beginner
552 pages
14h 54m
English
Content preview from Microsoft® Access® 2010 24-Hour TrainerBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
11
Table and Field Properties
Access table and field properties are used to control how objects appear and behave at run time. Every Access table has two types of properties: table properties and field properties. Table properties are set to make the table behave in the manner desired by the developer. All tables in Access 2010 have the same set of properties. Field properties are used to set how the fields in the table behave. In contrast to the properties of a table, each data type has a unique set of properties associated with it. This lesson discusses both table and field properties and provides some examples of how these can be applied to an Access database application.
LESSON SETUP
This lesson lists most of the Access table and field properties and provides an explanation of how they are used and set from the Table Design View mode designer. Note that table and field properties can be set using VBA code at run time, but that is beyond the scope of this lesson and is discussed later on in this book. You should be familiar with creating tables and fields in Access 2010 to complete this lesson successfully.
THE TABLE PROPERTY SHEET
When a table is open in Design View, the Table object's Property Sheet can be activated by clicking the Property Sheet button on the Table Tools Design Ribbon. When activated, the Property Sheet is located on the right side of the table design grid by default. This is the standard Property Sheet used to work with forms and reports and to control object ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.