Author
Released
10/10/2007Skill Level Beginner
Duration
Views
Hi and welcome to Microsoft Access 2007. I'm David Rivers. When it comes to creating and using databases on your desktop computer, Microsoft Access is the industry standard. Access is part of certain Microsoft Office Suite products but not all. You'll need Microsoft Office Professional, Ultimate, or Enterprise to get Access, along with all the regulars like Word, Excel, and PowerPoint. In this title we'll begin with a good foundation covering important database concepts and terminology before moving into the application itself.
Once inside Access 2007 and feeling comfortable in our new environment, we'll work through a common scenario as we create a relational database made up of tables, queries, forms, reports and more. Let's get started.
Related Courses
-
Access 2007: Queries
with Adam Wilbert2h 8m Intermediate -
Excel 2010: Tips, Tricks, and Shortcuts
with Dennis Taylor3h 43m Intermediate -
Access 2007: Shortcuts
with Alicia Katz Pollock3h 25m Intermediate
-
Introduction
-
Welcome47s
-
-
1. Getting Started with Access
-
Starting Access5m 14s
-
The Getting Started window4m 42s
-
The Quick Access toolbar3m 51s
-
The work environment9m 38s
-
2. Creating Databases and Tables
-
Working with fields5m 31s
-
Choosing keys3m 41s
-
Creating tables3m 10s
-
Creating fields6m 30s
-
Working with records5m 5s
-
Working with data7m 15s
-
Checking spelling5m 32s
-
3. Working with Fields and Records
-
Modifying table design6m 8s
-
Finding and editing records3m 39s
-
-
4. Creating Data Entry Rules
-
Setting field properties6m 58s
-
Using input masks5m 36s
-
Setting validation rules8m 26s
-
-
5. Relational Database Techniques
-
Creating key fields4m 56s
-
Creating table relationships5m 58s
-
Using subdatasheets4m 24s
-
-
6. Working with Queries
-
Creating flexible queries7m 27s
-
7. Working with Forms
-
Introduction to forms2m 8s
-
Creating subforms6m 18s
-
-
8. Working with Reports
-
Using the Report wizard6m 9s
-
Formatting reports9m 48s
-
Printing reports4m 34s
-
-
9. Working with Macros
-
Creating macros4m 57s
-
Validating data with macros7m 16s
-
-
10. Sharing Data with Word and Excel
-
Importing data into Access6m 14s
-
Using Package and Sign5m 27s
-
Sharing via email4m 29s
-
Exporting data to Excel4m 37s
-
-
11. Working with Charts
-
Working with charts7m 14s
-
Working with pivot charts5m 21s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome