WELCOME TO BLUE STAR LEARNING



- IT Training to meet your Business solution needs
- 40% Discount on Microsoft Office 2007/2010 training courses with a group of 2 or more students to maximize your training budget.
- We are Authorized Learning Partners with Adobe, CompTIA, Cisco, Microsoft, Red Hat and many more
- Customized learning environment either on-site or at Blue Star Learning site.
- iPhone Development Training, Virtualization platform training, and Artificial Intelligence Training
- Define customer's request and work closely to meet customer's needs
- Implement training curriculum
- Innovate customers platform solution
- Maximize training budgets
- Provide Instructor-led classroom learning
- Provide Prometric and Pearson VUE Testing
- Blue Star Learning is committed to providing the highest quality learning experience possible and we measure our success by one standard: Total Customer Satisfaction.
- We will be happy to provide you with a FREE class of your choice of a equal or lesser in value
- We have excelled ourselves with a A+ rating with Better Business Bureau
Course Date
Network+ Certification (2009 Objectives)
Lesson 1: Network basics
Topic A: Network concepts
Topic B: Network architectures
Topic C: The OSI model
Lesson 2: Wired computer-to-computer connections
Topic A: Wired network connections
Topic B: Network interface cards and modems
Lesson 3: Network-to-network connections
Topic A: Network-to-network connection components
Topic B: LAN wiring
Topic C: LAN wiring tests
Lesson 4: Wired internetworking devices
Topic A: Basic internetworking devices
Topic B: Specialized internetworking devices
Lesson 5: Wired communication standards
Topic A: The TCP/IP protocol suite
Topic B: TCP/IP
Topic C: DHCP servers
Lesson 6: Wireless networking
Topic A: Wireless network devices
Topic B: Wireless networking standards Topic C: Wireless configuration
Lesson 7: Security threats and mitigation
Topic A: Security threats
Topic B: Threat mitigation
Lesson 8: Security practices
Topic A: Operating systems
Topic B: Devices
Lesson 9: Network access control
Topic A: Authentication
Topic B: Public key cryptography
Topic C: Remote access
Topic D: Wireless security
Lesson 10: Monitoring
Topic A: Monitoring resources
Topic B: Event Viewer
Lesson 11: Troubleshooting
Topic A: Troubleshooting basics
Topic B: Troubleshooting the network
Topic C: Troubleshooting scenarios
Access 2007 - Level 2
Outline
Lesson 1:
Structuring Existing Data
Analyze Tables
Create a Junction Table
Improve Table Structure
Lesson 2:
Writing Advanced Queries
Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart
Lesson 3:
Simplifying Tasks with Macros
Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Lesson 4:
Making Effective Use of Forms
Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form
Lesson 5:
Making Reports More Effective
Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot
Lesson 6:
Maintaining an Access Database
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database
Testimonials
"Thank you for your help and generosity....CompTIA Server+ Training"
-- William B. from San Diego, CA
"Nimesh....thank you very much for helping us to pass our Server test! I am proud wearing my Blue Star Learning T-Shirt"
-- Andy A. from San Diego, CA
More...



Access 2007 - Level 1
Outline
Lesson 1: Exploring the Microsoft® Office Access™ 2007 Environment
Examine Database Concepts
Explore the User Interface
Explore the Ribbon
Customize the Access Environment
Obtain Help
Use an Existing Access Database
Lesson 2: Designing a Database
Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
Lesson 3: Building a Database
Create a New Database
Create a Table
Manage Tables
Create a Table Relationship
Save a Database as a Previous Version
Lesson 4: Managing Data in a Table
Modify Table Data
Sort Records
Work with Subdatasheets
Lesson 5: Querying a Database
Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Lesson 6: Designing Forms
View Data Using an Access Form
Create a Form
Modify the Design of a Form
Lesson 7: Generating Reports
View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat to a Report
Prepare a Report for Print
Lesson 8: Controlling Data Entry
Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field
Lesson 9: Joining Tables
Create Query Joins
Join Unrelated Tables
Relate Data Within a Table
Lesson 10: Creating Flexible Queries
Set Select Query Properties
Create Parameter Queries
Create Action Queries
Lesson 11: Improving Forms
Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform
Lesson 12: Customizing Reports
Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report
Lesson 13: Sharing Data Across Applications
Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document