Detailed information
| Duration: | 4 Hours |
|---|---|
| Price: | $30 |
| Type: | Courses |
| Method: | Online |
| Prepares for: | This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a Table, this course shows the user how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Introduction
Introducing Access 2010
Overview
Understanding the Backstage View
Reviewing the Ribbon
Customizing the Quick Access Toolbar
Understanding the Navigation Pane
Opening an Existing Database
Overview
Opening a Table
Reviewing the Anatomy of a Table
Using the Navigation Buttons
Using the Search Text Box
Using the Field Quick Filter Button
Navigating the Table Using the Keyboard
Creating a New Database and Tables
Overview
Advanced Table Design
Creating a New Table Using the Design View
Understanding the Table Design View
Reviewing the Calculated Field
Creating a New Table Using the Datasheet View
Adding Fields
Adding Predefined Fields
Working with the Table
Overview
Finding Data Using the Find Dialog Box
Using Wildcards
Changing Data Using the Replace
Adding Totals
Understanding Table Relationships
Viewing the Subdatasheet
Creating a Select Query
Overview
Understanding the Different Query Types
Using the Query Wizard
Reviewing the Query Design Window
Running Queries
Entering Criteria
Range Operators
Creating Simple Forms
Overview
Creating a Simple Form Using the Form Button
Understanding the Form Design Window
Selecting, Moving and Resizing Controls
Deleting Controls
Creating a New Form Using the Form Wizard
Creating a Navigation Form
Creating Simple Reports
Overview
Creating Simple Reports Using the Report Wizard
Understanding the Report Design Window
Understanding the Report Bands
Selecting, Moving and Resizing Controls
Changing the Page Layout
Conclusion
Introducing Access 2010
Overview
Understanding the Backstage View
Reviewing the Ribbon
Customizing the Quick Access Toolbar
Understanding the Navigation Pane
Opening an Existing Database
Overview
Opening a Table
Reviewing the Anatomy of a Table
Using the Navigation Buttons
Using the Search Text Box
Using the Field Quick Filter Button
Navigating the Table Using the Keyboard
Creating a New Database and Tables
Overview
Advanced Table Design
Creating a New Table Using the Design View
Understanding the Table Design View
Reviewing the Calculated Field
Creating a New Table Using the Datasheet View
Adding Fields
Adding Predefined Fields
Working with the Table
Overview
Finding Data Using the Find Dialog Box
Using Wildcards
Changing Data Using the Replace
Adding Totals
Understanding Table Relationships
Viewing the Subdatasheet
Creating a Select Query
Overview
Understanding the Different Query Types
Using the Query Wizard
Reviewing the Query Design Window
Running Queries
Entering Criteria
Range Operators
Creating Simple Forms
Overview
Creating a Simple Form Using the Form Button
Understanding the Form Design Window
Selecting, Moving and Resizing Controls
Deleting Controls
Creating a New Form Using the Form Wizard
Creating a Navigation Form
Creating Simple Reports
Overview
Creating Simple Reports Using the Report Wizard
Understanding the Report Design Window
Understanding the Report Bands
Selecting, Moving and Resizing Controls
Changing the Page Layout
Conclusion
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
CompuWorks
When it comes to finding the best training in New England and across the country, CompuWorks is the hands down leader.
For over 23 years CompuWorks has been creating some of the most successful award-winning training programs in the country.
Our goal is to provide our customers with the best training solution possible. This means we don’t use a cookie cutter approach but customize a learning plan that is designed to fit each organization’s unique business needs. Our ability to be innovative, adaptable and creative in handling challenges is the key to our success.
CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Learning Solutions & Information Worker Solutions.
For over 23 years CompuWorks has been creating some of the most successful award-winning training programs in the country.
Our goal is to provide our customers with the best training solution possible. This means we don’t use a cookie cutter approach but customize a learning plan that is designed to fit each organization’s unique business needs. Our ability to be innovative, adaptable and creative in handling challenges is the key to our success.
CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Learning Solutions & Information Worker Solutions.