In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access 2010 relational database application.
- Course Outline
In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2010 relational database application.
Lesson 1: Getting Started with Access 2010Topic 1A: Identify the Elements of the User Interface
Topic 1B: Identify the Tabs and Commands on the Ribbon
Topic 1C: Obtain Help in Access
Lesson 2: Identifying the Components of a Database
Topic 2A: Define Database Concepts
Topic 2B: Identify the Components of a Database
Topic 2C: Examine the Relational Database Design Process
Lesson 3: Organizing Data in Tables
Topic 3A: Create a Table
Topic 3B: Modify Table Data and Properties
Topic 3C: Create a Table Relationship
Lesson 4: Viewing Data in Tables
Topic 4A: Sort Records
Topic 4B: Filter Records
Topic 4C: View Data from Related Tables
Lesson 5: Querying a Database
Topic 5A: Create a Query
Topic 5B: Add Criteria to a Query
Topic 5C: Add a Calculated Field to a Query
Topic 5D: Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
Topic 6A: Create a Form
Topic 6B: View Data Using an Access Form
Topic 6C: Modify a Form
Lesson 7: Generating Reports
Topic 7A: View an Access Report
Topic 7B: Create a Report
Topic 7C: Add a Calculated Field to a Report
Topic 7D: Format the Controls in a Report
Topic 7E: Apply a Theme to a Report
Topic 7F: Prepare a Report for Print
- Prerequisites & Certificates
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders
Certificate of Completion
- Cancellation Policy
Cancellations or postponements received more than ten business days prior to the first day of the course, will be subject to a 15% administration fee, and course ware fees where applicable. The cost of the course is payable, in full, for any cancellations or postponements received within ten business days, or less, prior to the first day of the course.
- Map & Reviews
TekSource Corporate Learning
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 5711 times.