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.
10
Access 2010 Data Types
Access 2010 (and other databases systems for that matter) define different representations of data, such as numbers, text, and other common items stored in a database table field, as specific data types to be stored within the field. Common data types are numbers, strings of characters, and date and time values. Access has special data types, such as OLE Object, Calculated, and Attachment fields, which hold specific types of objects or perform table-level calculations. As you have seen in the previous two lessons, each field in an Access database must have a data type defined for that field. Selecting the correct data type to match the characteristics and use of the data being stored is an important part of the design process. This lesson is dedicated to discussing the different data types supported for Access table fields and is designed to help define which values each of those data types can represent.
LESSON SETUP
In this lesson you learn about the different data types available for table fields in Access 2010. You should be familiar with creating tables and understand the basics of how they work. Each of the supported Access 2010 table field data types is discussed in detail.
ACCESS 2010 FIELD DATA TYPES
As noted earlier in this lesson, Access table fields are defined as specific data types and the data type selected for the field will determine the data values that can be stored in that field. The following list shows each of the Access 2010 data ...
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.