MS Access: Intermediate (Level 2)

This course gives those who have little or no experience of working with MS Access a detailed introduction to this database software. During the course you will learn how to create a database with tables, forms, reports and queries. You will also gain an understanding of the advantages that using an Access Database can bring to your job role or business.

Content:

• Getting Started With Microsoft Access
  • Microsoft Access Overview Database Design Theory
  • What is a Relational Database?
  • Screen Elements and Help
  • Basic Window Elements
  • Exploring Microsoft Office Backstage
  • Working with The Ribbon
  • Customizing the Quick Access Toolbar
  • Working with KeyTips
• Tables
  • Using the Table Wizards
  • Manual Creation of Tables
  • Fields, Data Types and Properties
  • Input Masks
  • Data Validation
  • Primary Keys and Relationships
• Importing Data
  • Importing from a Spreadsheet File
  • Importing from a Text File
• Inputting Data
  • Adding Data using the Table View
  • Adjusting the Column Widths
• Finding Records
  • Using the Find Feature to Find Records
  • Using the Replace Feature to Replace Text
• Filters
  • Using the Filter Button to Find Records
• Queries
  • Designing Queries
  • Query Wizard Overview
  • Sorting and Searching Queries
  • Multi-Table Relationship Queries
  • Update, Append and Delete Action Queries
• Forms
  • Introduction to Form Design
  • Form Wizards
  • Toolbox Controls
  • Combo Boxes and Command Buttons
  • Main/Sub Form Creation
  • Creating a Menu Form
• Reports
  • Report Wizard
  • Creating Reports
  • Printing Reports