Mirosoft Access Training Courses

Microsoft Access Training Orlando

Access Level 1

  • Plan and design databases
  • Create tables using the Wizard and from scratch
  • Set up Primary keys
  • Find and edit records
  • Data entry rules
  • Field properties
  • Input masks
  • Validation rules
  • Create and use basic queries
  • Calculated fields in queries
  • Create forms using the Wizard and from scratch
  • Design view
  • Sort and filter records
  • Create reports using the Wizard and from scratch
  • Modify and print reports
Microsoft Access Training Orlando

Access Level 2

  • Relate tables
  • Implement referential integrity
  • Lookup fields
  • Subdatasheets
  • Complex queries
  • Joining tables in queries
  • More Calculated fields in queries
  • Summarize and group values in queries
  • Advanced form design
  • Add unbound controls, graphics, calculated values and combo boxes
  • Advanced Reports
  • Customized headers and footers
  • Adding calculated values
  • Printing
  • Labels
  • Charts in forms
  • Charts in reports
  • PivotTables and PivotCharts
Microsoft Access Training Orlando

Access Level 3

  • Simple queries in SQL
  • Assign SQL queries to controls
  • Advanced queries – Crosstab queries, Parameter queries, Action queries
  • Create, run and modify macros
  • Attach macros to controls
  • Macros that require user input
  • AutoKeys – keyboard shortcuts
  • AutoExec macros – when opening a database
  • Macros for data transfer
  • Import objects
  • Export objects
  • Interact with XML documents
  • Link Access objects
  • Database management
  • Optimize resources
  • Protect databases
  • Compact and Repair
  • Backup your database
Orlando Microsoft Office Training:
We are subject experts in Excel, PowerPoint, Outlook, Word, Access, OneNote, ProjectAdobe Acrobat, Photoshop. Software Savvy Orlando computer training is customized to meet computer users’ specific needs. We have helped countless numbers of people become more efficient, more productive and more profitable.