Learning outcomes:

Upon completion of this Microsoft Access training course, you should be able to:

• Understand how Access is used and how to navigate around it
• Design a database with lookup tables
• Create a database structure using Access
• Modify the structure of an existing table
• Add records to a new table
• Add transactional records to a lookup database
• Work with the records in a database table
• Sort and filter records in a table
• Create simple and effective queries

What will you learn on this course?

• Microsoft Access orientation
  
  Understanding Microsoft Access; Starting Access; Understanding The Start Screen; Creating A New Blank Database; Understanding The Backstage View; Opening An Existing Database File; Understanding The Access Screen; Using The Ribbon; Working With The Navigation Pane; Adding Commands To The QAT; Working With Touch Mode; Working With A Table; Working With Other Database Objects; Closing A Database File; Exiting From Access


• Designing a lookup database
  
  Understanding How Access Stores Data; Understanding Access Data Types; Scoping Your New Database; Identifying Table Problems; Refining Table Structures; Finalising The Design


• Creating a lookup database
  
  Creating A New Database File; Creating The Lookup Table; Defining The Primary Key; Saving And Closing A Table; Creating The Transaction Table; Understanding Lookup Table Relationships; Connecting To A Lookup Table; Viewing Table Relationships


• Modifying table structures
  
  Opening An Existing Table; Adding Fields To An Existing Table; Understanding Field Properties; Changing Field Size; Changing Field Names; Changing Decimal Places; Changing Date Formats;Indexing Fields; Deleting Fields From A Table; Copying A Table Within A Database; Deleting A Table From A Database File


• Working with records
  
  Table Navigation; Navigating To A Specific Record; Editing A Record; Deleting Record Data; Undoing A Change. Deleting A Record; Deleting Several Records; Searching In A Table; Searching In A Field; Finding And Replacing; Printing Records From A Table;Compacting A Database


• Creating queries
  
  Understanding Queries; Creating A Query Design; Working With A Query; Changing A Query Design; Applying Record Criteria; Clearing Selection Criteria; Saving A Query; Running Queries From The Navigation Pane; Deleting A Query; Assignment: Creating Queries


• Creating and using reports
  
  Understanding Reporting In Access; Creating A Basic Report; Working With Existing Reports; Previewing And Printing A Report; Changing The Report Layout; Using The Report Wizard; Creating A Grouped Report; Creating A Statistical Report; Working With Grouped Reports


• Creating and using forms
  
  Understanding Forms; Creating A Basic Form; Creating A Split Form; Binding A Form To A Query; Using The Form Wizard; Working With Existing Forms; Editing Records In A Form; Deleting Records Through A Form; Deleting An Unwanted Form