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.
8
Creating a Table in Datasheet View
Tables are probably the most important part of a database. Tables are made up of sets of fields (columns) that are defined as specific data types. Tables store data in these fields in the form of individual records (rows) in the table. Access makes it very easy to create new tables and edit existing ones, and a number of methods exist for doing so in Access 2010, such as Datasheet or Design View modes. This lesson discusses the basics of building tables for a database application using Datasheet View mode in Access 2010.
LESSON SETUP
In this lesson, you learn how to create a table using the Datasheet View designer in Access 2010. Datasheet View allows you to quickly add fields, set the data type of the field, and enter data into the table, all in a tabular layout that is similar to an Excel worksheet.
CREATING TABLES IN ACCESS 2010
The Create Ribbon offers three basic methods for creating tables. The Table button creates and opens a new table in Datasheet View mode. The Table Design button opens the table in Design View mode and is the traditional method of creating tables. Design View also provides easy access to all the properties of the fields in the table. This allows you greater control when designing the table. The SharePoint Lists button allows the user to create linked tables to a new SharePoint list. This lesson discusses creating Access table objects in an ACCDB database file using the Table Design button to create the table in Datasheet ...
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.