Take this
course

Office Productivity / Microsoft

Microsoft Access 2010 Training - Beginners/Intermediate

Upgrading your Microsoft Access skills is a smart move for any professional.

Description

Microsoft Access 2010 Training - Beginners/Intermediate by Simon Sez IT is a 7-hour course filled with all the information you need to create, design, and customize high-performing databases. Your professional trainer will introduce you to Microsoft’s “Ribbon” interface, showing you tips and techniques to leverage its features for more efficient database management. Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier. Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports. Before the “Microsoft Access Training: Microsoft Access Tutorial” course is over, we’ll cover all key areas of the program: custom queries using defined criteria, select queries, updating queries, appending queries, deleting queries, inner joins, outer joins, table queries, and mail merges.
Full details

Curriculum

  • Getting to Know the Workspace
    Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
    15:39
    Start/Exit, Help Features, Shortcuts, Views, Templates
    15:32
  • Access Basics
    Understanding Database Components15
    15:15
    Introduction to Design of a Database
    14:20
    Introduction to Building a Database
    13:28
  • Tables
    Creating Tables & Basic Setup of Relationships
    15:26
    Using Quick Parts to Setup New Table, Importing Spreadsheet
    16:19
    Entering Data Types into Tables
    15:19
    Table Structures
    15:16
    Changing Table Attributes, Copy, Rename, Delete Records
    16:22
    Table and Field Properties
    15:56
  • Forms
    Auto-Create Forms, Filtering & Searching
    15:13
    Types of Different Forms & Creating New
    14:57
    Improve Look, Style, & Feel of Forms
    15:14
    Adding Fields to Existing Form
    15:59
  • Expression Builder
    Understanding and Setting Up the Expression Builder
    14:58
  • Conditional Formatting
    Format Control on Forms/Reports
    14:59
  • Sorting and Filtering
    Sorting Single & Multiple Columns; Filter One Field Data Records
    15:34
    Sorting & Filtering Data in Form View; Find & Replace in Forms
    15:11
  • Reports
    Understanding Reports & Structure
    15:24
    Creating Reports; Using Print Preview to Check Report Outcome
    15:36
    Advanced Reporting; Formatting Reports
    15:24
    How to Improve Report Design, Add Existing Fields; Group/Sort
    14:26
  • Queries
    Select Queries; Sorting; Defined Criteria
    15:00
    Change Fields wthin Query; Specifying Criteria for Numbers/Text
    15:32
    Update Queries; Append Queries; Delete Queries
    15:57
    Inner/Outer Joins; Make Table Queries; Mail Merge
    16:28
  • Security
    Securing Database and Views; New Features
    14:02

Skills

  • Data Management
  • Microsoft Access
  • Microsoft Office

Similar Courses

More Courses by this Instructor