Microsoft Office Access 2010 - CA1B

 

Description
Are you an office worker who needs to design, implement and maintain basic Access databases? Perhaps you are someone who's been using Excel to store all of your company lists? If this sounds like you, then this is the course for you. Microsoft has really outdone itself with all of the amazing new features to Access 2010, and this course covers them all. If you are new to databases then ATS's Access 2010 course is where you want to start. Jason Manibog will take you step-by-step through this course; starting with understanding what a Database is and how data relates to each other. Learn the process of planning and implementing a database effectively and then learn to use the tools provided in Access 2010 to design and maintain a basic database.


Benefits
Learn to create, modify, and personalize objects
Learn to work independently or in collaboration with others on database projects
Learn to ask and answer questions from others about the database
Create and/or modify a simple Access database

   
   
   
   
   
Module 1


Section A: Introduction
• Database Defined
• Available Database Platforms
• Access Advantages and Disadvantages


Section B: Access 2010 Tour
• Opening Access and Databases
• Interface Overview
• Quick Access Toolbar
• Introduction to Backstage
• Getting Help
• Understanding Database Parts


Section C: Working with Tables and Forms
• Navigating Tables
• Sorting and Filtering Table Data
• Entering and Editing Table Data
• Navigating Forms
• Entering and Editing Form Data
• Form Types
• Working with Multiple Items


Section D: Working with Queries and Reports
• Running Queries
• Running Reports

 


Section E: Database Organization Techniques
• Using the Navigation Pane
• Access Naming Conventions
• Copying and Renaming Objects
• Deleting Objects

Section F: Customizing Access
• Customizing Quick Access Toolbar
• Customizing the Ribbon
• Backstage Customization Options
• Additional Backstage Options

Section G: Understanding Relational Databases
• Flat vs. Relational Databases
• Relational Database Rules

Section H: Planning a Database
• Defining Database Needs
• Mapping Out a Database



Module 2


Section A: Building a Database
• Database Options
• Database from Template
• Database from Scratch


Section B: Building Tables
• Application Parts
• Using Application Parts
• Using Naming Conventions
• Tables from Scratch
• Create Table in Design View

Section C: Table Design Basics
• Good Table Design Basics
• Defining the Data Type
• Yes/No Data Type
• Other Data Types
• Saving and Testing Tables


Section D: Adjusting Table Design
• Understanding Field Properties
• Database Adjustment Feedback
• Edit Field Size
• Removing Fields
• Text vs. Numeric Field Options
• Adding Descriptions
• Renaming Fields
• Importance of Field Consistency
• Required Fields





Section E: Data Validation and Input Masks

• Validation Rules
• Building the Rule
• Specify Validation Text
• Testing Validation Rule
• Input Masks
• Input Mask Wizard

Section F: Lookups
• Lookups Defined
• Creating a Lookup
• Using the Lookup Wizard
• List-Based Lookups

Section G: Table Relationships
• Understanding Table Relationships
• Creating a Table Relationship
• Referential Integrity
• Determine Relationship Options
• Manually Create Table Relationship


Section H: Importing Data
• Importing Data into a New Table
• Importing Data into an Existing Table
• Troubleshooting Import Errors
• Linked Tables

Module 3


Section A: Building Forms Automatically

• Introduction to Forms
• Creating a Standard Form
• Form View Options
• Creating a Split Form
• Using the Form Wizard
• Creating a Form/Subform

Section B: Building Forms Manually
• Creation Process Defined
• Creating Forms in Design View
• Creating a Blank Form
• Create Form using Application Parts
• Manage Active Content and Security
• Customizing Forms in Design View


Section C: Customizing and Personalizing Forms
• Form Customization Techniques
• Using and Customizing Themes
• Alternating Row Color
• Form Personalization Techniques
• Inserting an Image
• Adding Background Images
• Conditional Formatting


Section D: Working with Form Layout
• Form Design Options
• Using the Layout View
• Using Stacked Layout
• Converting Layouts
• Controlling Margins and Padding
• Unstacking a Layout

 


Section E: Working with Form Design

• Using the Design View
• Object Property Considerations
• Getting the Form Properties
• Controlling Tab Order


Section F: Adding Controls to Forms

• Controls Defined
• Adding a Button
• Adding a Combo Box
• Adding a Text Box


Section G: Filtering Data with Forms
• Form-Based Filtering
• Right-Click Filter Options
• Filtering By Selection
• Filtering By Form
• Using Wildcards
• Filtering Across Multiple Fields
• Either/Or Filters


Section H: Building Navigation Forms
• Understanding Switchboards
• Using the Switchboard Manager
• Editing Switchboard Items
• Running the Switchboard
• Creating a Navigation Form


Module 4


Section A: Building a Query with a Wizard
• Purpose of Queries
• Building a Query
• Simple Query Wizard
• Query Design Window
• Using Other Wizards


Section B: Building a Query from Scratch
• Defining a Queried Table
• Adding Fields to a Query
• Testing the Query
• Hiding and Rearranging Fields
• Joining Tables in Queries
• Inner vs. Outer Joins
• Convert Inner to Outer Join


Section C: Basic Criteria
• Criteria Types
• Filtering Data with Criteria
• Using AND and OR Criteria
• Using the IN Criteria


Section D: Comparison Criteria
• Building a Comparison Query
• Using < and >
• Using BETWEEN
• Using NULL and NOT
• Querying using Wildcards
• Using Single Character Wildcards



Section E: Performing Calculations

• Understanding Calculations
• Building a Calculated Field
• Using Expression Builder
• Understanding Expression Builder
• Writing and Formatting Expressions
• Concatenating Fields


Section F: Working with Calculated Totals
• Using the Total Row
• Performing Queries Using Aggregates
• Calculated Total Considerations


Section G: Advanced Select Queries
• Crosstab Query Defined
• Crosstab Query Example
• Editing Query Properties
• Parameter Query Defined
• Parameter Query Example

Section H: Action Queries
• Action Query Defined
• Enabling Active Content
• Make-Table Query Example
• Running an Action Query
• Append-Table Query Example
• Update Query Example
• Update Query Errors
• Run Update Query
• Delete Query Example


Module 5


Section A: Reports
• Building Reports
• Report Button
• Report Wizard
• Reports from Scratch
• Viewing Options


Section B: Report Formatting
• Report Themes
• Modifying Report Themes
• Conditional Formatting
• Expression Builder


Section C: Basic Report Design
• Report Design Concepts
• Adding Footer Information
• Arranging Report Fields
• Customizing a Report Layout
• Adding Hyperlinks
• Adding Charts


Section D: Grouping Data on Reports
• Adding Totals to Reports
• Adding Calculated Fields to Reports
• Building an IF Statement


Section E: Controlling Page Layout

• Report Layout Considerations
• Working with Page Breaks
• Using Print Preview
• Modifying and Resizing Fields
• Changing Page Size
• Controlling Margins and Page Layout


Section F: Building Specialized Reports
• Parameter Reports Defined
• Building a Parameter Report
• Enter a Different Paramenter
• Building a Mailing Labels Report
• Building a Multi-Column Report


Section G: Introduction to Macros
• Macros Defined
• Form Data Validation Macros
• Report Data Validation Macros
• Table Data Validation Macros

Section H: Finalizing the Database
• Exporting the Database
• Saving Export Steps
• Publishing the Database
• Saving the Database as a Template

 

Price £ 560 (Bundle of 5)

Complementary Courses
Word 2010
Excel 2010
Outlook 2010
PowerPoint 2010

<<Back <<Contact Us