Microsoft Access 365 Foundation Training Materials

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