Microsoft Access 365 Courseware – Foundation
Part of the Microsoft Office 365 Courseware Library

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
Office 365 Training Courseware