Learn to Track Data Like a Pro though our Microsoft Project and Microsoft Access Training

Learn everything you need to know to design a solid relational database. Topics include:

• Database basics
• Understanding Access Objects
• Designing a Table
• Restructuring a Table
• Field Types
• The Primary Key
• Using Input Masks
• Data Validation
• Filtering Records
• Relating Tables
• Query Basics
• Form Basics
• Report Basics

Learn the tricks to analyzing, summarizing, and calculating data with Access Queries. Topics include:

• Using Wildcards in a Query
• Compound Queries
• Operators   
• Creating Calculated Fields
• Using Summary Operators
• Querying Multiple Tables
• Action Queries
• Parameter Queries
• Crosstab Queries    

Design easy to use forms and great reports. Topics include:

• Designing Forms
• Adding Charts to a Form
• Working with Bound/Unbound Objects
• Adding a Combo/List Box
• Creating an Option Group
• Adding Command Buttons
• Adding Control Tips
• Adding a Background Picture
• Creating Custom Reports 
• Adding a Calculated Control
• Navigation Forms
• Macros 

Learn how to create an estimated project time line by tracking the tasks, resources, and costs of a project. Topics include:

• Creating a New Project Plan
• Defining a Project
• Assigning a Project Calendar 
• Adding Tasks 
• Importing Tasks From Other Programs
• Creating Work Breakdown Structure 
• Defining Task Relationships
• Scheduling Tasks 
• Adding Resources
• Creating a Resource Calendar
• Entering Costs
• Assigning Resources to Tasks
• Resolving Resource Conflicts
• Optimizing a Project Plan
• Setting a Baseline

Planning a project is just the start. This course covers the features needed to analyze and track a Project from start to end. Topics Include:

• Entering Task Progress 
• Updating Task Progress with SharePoint 
• Viewing Project Progress 
• Adding Custom Fields
• Creating Custom Views
• Analyzing a Project Plan
• Rescheduling Tasks
• Updating a Baseline
• Reporting Options
• Creating a Project Plan Template
• Sharing Resources
• Linking Project Plans