August 2013
Beginner
672 pages
14h 31m
English
Content preview from Office 2013 Digital Classroom
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,
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.
Access Lesson 2: Getting Started with Microsoft Access 2013
In this lesson, you will become more familiar with creating tables and importing data into Microsoft Access 2013. You will create basic tables and learn about different field data types. You will also import data into Access from Microsoft Excel.
What you’ll learn in this lesson:
- • Creating a new blank database and a template
- • Creating a table and fields
- • Using Design view to edit a table table and create a primary key
- • Importing Microsoft Excel data into Access
Starting up
You will work with files from the Access02lessons folder. Make sure that you have loaded the OfficeLessons folder onto your hard drive from www.digitalclassroombooks.com/Office2013. If you need further instructions, see “Loading lesson files” in the Starting up section of this book.
Access 2013 database types
Access 2013 has two types of databases:
1 Desktop (standard) database, which is stored on your computer, a network, or another computer storage location and run directly from the location on your computer. The exercises in this lesson involve the desktop database type.
2 An Access web app, which was introduced with Access 2013. This new type of database can be built from Access, and then used and shared with others as a SharePoint app in a web browser. You create the app by selecting the type of data you want to track (contacts, tasks, ...
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.