Microsoft Access 365 Courseware – Foundation

Part of the Microsoft Office 365 Courseware Library

Microsoft Word Access Materials

Access 365 Training Materials – Foundation Level

 

ACCESS 365 DATABASE CONCEPTS

  • What is a database?
  • Database examples
  • What is a relational database?
  • What is a table?
  • What is a record (row)?
  • What is a field (column)?
  • What is data?
  • The difference between data and information
  • Data types
  • Common uses of large-scale databases
  • Keeping data discrete
  • Each field should contain only one item
  • Database designers, database administrators and database users

 

OPENING A DATABASE & SECURITY ISSUES

  • Opening a database within your samples folder
  • Trusted locations – using the trust center
  • Setting the default folder location within Access

 

TABLES, FIELDS AND FIELD TYPES

  • Creating a new blank database
  • Adding fields and setting the field type
  • About Access data types
  • Closing and naming a table

 

TABLE NAVIGATION & MODIFICATION

  • Opening a table within a database
  • Switching between ‘datasheet view’ and ‘design view’
  • Adding records to a table
  • Saving the changes made to a table
  • Navigating through records within a table
  • Adjusting the column width
  • Automatically resizing a column width to fit contents
  • Moving a column to rearrange the column order

 

ACCESS 365 FIELD PROPERTIES

  • Field properties
  • Input masks
  • Validating numbers
  • Validating dates
  • Data entry required / not required
  • Field properties – reference materials
  • Field properties – logical operators
  • Field properties – validation rule examples
  • Field properties – general
  • Field properties – format
  • Field properties – input mask characters
  • Field properties – input mask examples

 

MANIPULATING TABLES & RECORDS

  • Renaming a table
  • Editing data within a record
  • Deleting data within a record
  • Using the undo command
  • Deleting a single record
  • Deleting multiple records
  • Using save as to back up the database using a different file name
  • Deleting a table

 

ACCESS 365 PRIMARY KEYS & INDEXING

  • Defining a primary key
  • Indexing – reference notes
  • Creating a single-field index
  • Creating a multiple-field index
  • Deleting multi-field indexes

 

FILTERING WITHIN ACCESS 365

  • Text filters
  • Applying a single filter
  • Clearing a single filter
  • Creating multiple filters
  • Clearing multiple filters

 

SORTING WITHIN ACCESS 365

  • Sorting records a-z
  • Sorting records z-a
  • Removing a sort
  • Sorting on multiple fields

 

SEARCHING WITHIN ACCESS 365

  • Searching through records
  • Access 365 relationships
  • Table relationships
  • One-to-many relationship
  • Many-to-many relationship
  • One-to-one relationships
  • Creating relationships between tables
  • About referential integrity
  • Enabling referential integrity
  • Cascade options
  • Cascade update related fields
  • Cascade delete related records
  • Enabling cascade options
  • Deleting relationships

 

ACCESS 365 FORMS

  • Forms overview
  • Creating forms
  • Modifying forms
  • Modifying a form title
  • Changing a form logo
  • Modifying a form label
  • Saving a form
  • Form view
  • Adding and formatting attachments
  • Modifying data within records
  • Deleting records using a form
  • Adding records using a form
  • Adding or deleting text in a record using a form
  • Closing forms
  • Opening forms
  • Deleting a form
  • Filtering a form
  • Removing a filter from a form
  • Inserting and modifying a form header
  • Inserting and modifying a form footer