Access 2010 Introduction
Take This Course $250
by CompuWorks
This course covers the basics functions of Access 2010. After an introduction to database concepts and the Access environment and Help systems, you will learn how to open and use existing databases and design and create databases. Next, you will work with tables, fields, and records; sort, search and filter data; and set field properties and data entry rules. You also will learn to create queries, forms, and reports.
MODULE 1: Introduction
-
Video Lesson 1:
Introduction
MODULE 2: Introducing Access 2010
-
Video Lesson 1:
Using the File tab
-
Video Lesson 2:
Using Templates
-
Video Lesson 3:
Reviewing the Ribbon
-
Video Lesson 4:
Customizing the Quick Access Toolbar
-
Video Lesson 5:
Understanding the Navigation Pane
MODULE 3: Opening an Existing Database
-
Video Lesson 1:
Opening a Database
-
Video Lesson 2:
Using the Navigation Pane
-
Video Lesson 4:
Reviewing the Anatomy of a Table
-
Video Lesson 5:
Adding a Record
-
Video Lesson 6:
Using the Navigation Buttons
-
Video Lesson 7:
Using the Search Text Box
-
Video Lesson 8:
Using the Field Quick Filter button
-
Video Lesson 9:
Reordering Columns
MODULE 4: Creating a New Database
-
Video Lesson 1:
Creating a New Table in Design View
-
Video Lesson 2:
Understanding the Table Design View
-
Video Lesson 3:
Understanding the Different Data Types
-
Video Lesson 4:
Adding Fields
-
Video Lesson 5:
Adding Calculated Fields
-
Video Lesson 6:
Adding and Validating Record Data
-
Video Lesson 7:
Using the Data Sheet View
-
Video Lesson 8:
Adding Pre-Defined Fields
-
Video Lesson 9:
Modifying Fields
MODULE 5: Working With the Table
-
Video Lesson 1:
Using the Find Dialog Box
-
Video Lesson 2:
Searching With Wildcards
-
Video Lesson 3:
Using the Replace
-
Video Lesson 4:
Adding Totals
-
Video Lesson 5:
Understanding Table Relationships
-
Video Lesson 6:
Adding the Subdatasheet
MODULE 6: Creating a Select Query
-
Video Lesson 1:
Using the Query Wizard
-
Video Lesson 2:
Using the Query Design View
-
Video Lesson 3:
Setting Query Criteria
-
Video Lesson 4:
Creating a New Query
-
Video Lesson 5:
Using Range Operators
MODULE 7: Creating Simple Forms
-
Video Lesson 1:
Creating Simple Forms Using the Form Wizard
-
Video Lesson 2:
Understanding the Form Design View
-
Video Lesson 3:
Selecting, Moving and Resizing Controls
-
Video Lesson 4:
Creating a Simple Form Using the Form Button
-
Video Lesson 5:
Using Labels
-
Video Lesson 6:
Formatting Controls
-
Video Lesson 7:
Setting Tab Order
MODULE 8: Creating Simple Reports
-
Video Lesson 1:
Creating Simple Reports Using the Report Wizard
-
Video Lesson 2:
Selecting, Moving and Resizing Controls
-
Video Lesson 3:
Using Report Bands
-
Video Lesson 3:
Using Groups
-
Video Lesson 4:
Using Controls
-
Video Lesson 5:
Changing the Page Layout
-
Video Lesson 6:
Conclusion
View All Users Who Viewed This Course Also Viewed
CompuWorks
CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools. CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.
Other Courses from CompuWorks
-
$250Word 2007 Intermediate
-
$250Word 2007 Introduction
CompuWorks authored 51 courses
View All
No User Found
0 Reviews