Microsoft Access 365 Training Materials – Intermediate

Part of the Microsoft Office 365 Courseware Library

Microsoft Word Access Materials

Access 365 Training Materials – Intermediate Level

 

TRUSTED LOCATIONS & DEFAULT LOCATIONS

  • Specifying a trusted location
  • Specifying the default file location

 

QUERIES

  • Creating a query
  • Adding (and removing) criteria to a query
  • Running a query
  • Editing criteria in a query
  • Creating a two table query and sorting the results
  • Refining your query
  • What are wildcards?
  • Deleting a query
  • Hiding and un-hiding fields within a query

 

REPORTS

  • What are reports?
  • Creating a simple report
  • Using the report wizard
  • Modifying the report view
  • Widening a report column
  • Modifying the report title
  • Adding a logo to a report
  • Formatting a form using themes
  • Modifying field names within a report
  • Inserting and formatting the date & time
  • Adding existing fields to a report
  • Resizing reports for printing
  • Totals
  • Closing a report
  • Deleting a report

 

LOOKUP TABLES AND INPUT MASKS

  • What is a table lookup?
  • Creating a lookup within a field
  • Modifying a lookup within a field
  • Deleting a lookup within a field
  • What is an input mask?
  • Creating an input mask
  • Modifying an input mask
  • Deleting an input mask
  • What does data entry required/not required mean?
  • Modifying a field to require data entry
  • Modifying a field so that it does not require data entry

 

RELATIONSHIPS

  • What is a one-to-one relationship?
  • Creating a one-to-one relationship
  • Modifying a one-to-one table relationship
  • Deleting a one-to-one table relationship
  • What is a one-to-many table relationship?
  • Creating a one-to-many relationship
  • Modifying a one-to-many relationship
  • Deleting a one-to-many relationship
  • What is a many-to-many relationship?
  • Creating a many-to-many relationship using a junction table
  • Modifying or deleting a many-to-many relationship
  • What is referential integrity?
  • Enforcing referential integrity
  • Applying automatic updating of related fields
  • Applying automatic deletion of related records

 

JOINS

  • Applying an inner join
  • Modifying an inner join
  • Applying an outer join
  • Modifying an outer join
  • Creating a subtract join
  • Modifying a subtract join
  • What is a self join?
  • Applying a self join

 

EXPORTING

  • What does exporting data mean?
  • What is a spread sheet format?
  • What is text only and csv format?
  • What is a pdf file?
  • What is an xml file?
  • Exporting a table as an excel file
  • Exporting a table as a text file (keeping data format & layout)
  • Exporting a table as a text csv formatted file
  • Exporting a table as a pdf formatted file
  • Exporting a table as an XPS formatted file

 

PRINTING

  • Considerations before printing
  • Print previewing
  • Which orientation, portrait or landscape?
  • Adjusting the layout within print preview
  • Setting page margins
  • Printing a complete table
  • Printing selected records
  • Printing a query or reports
  • Printing forms