About the course
The Office 365 - Access - Level 2 course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will manage databases, perform Backups and Split databases. You will also build and design tables, import data, create relationships, and modify options.
Modules
There are 8 modules in this course
- Managing Databases
- Application Parts
- Backup and Splitting Databases
- Table Basics
- Table Design
- Table Relationships
- Importing Data
- Modifying Options
Course features
- Simulation training replicates the software you are learning providing a realistic learning experience.
- Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
- Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
- Assess your skills at any time by undertaking the Course Test.
- Lessons can be completed within 30 minutes so training can be undertaken in “bite” size pieces.
- Bookmarking allows you to learn in multiple training sessions.
- Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
- Designed for people who require initial and refresher training activities.
- Available on-line 24 hours a day.
- Version for Mobile Devices.
- Review course content with eBooks
You'll learn how to:
Managing the Access Environment
Managing Databases
- Managing a Database;
- Opening Databases;
- Navigation Pane;
- Save Object As Command;
- Adding Table Descriptions;
- Renaming Objects;
- Deleting Objects;
- Navigation Pane Options;
- Compact and Repair Databases;
- Protect Databases.
Application Parts
- Application Parts;
- Saving Database as a Template;
- Creating Application Parts;
- Using Application Parts;
- Quick Start options;
- Blank Forms;
- Saving Databases.
Backup and Splitting Databases
- Database Backup;
- Saving to OneDrive;
- Restoring Backups;
- Importing Database Objects;
- Saving for Backward Compatibility;
- Splitting Databases;
- Linking to Databases.
Building Tables
Table Basics
- Creating Tables in Design View;
- Adding Fields;
- Editing Fields;
- Deleting Fields;
- Viewing Field Properties;
- Setting Field Properties;
- Adding Table Data;
- Adding New Records;
- Deleting Records;
- Modify Table Data;
- Deleting Table Data;
- Navigation Buttons;
- Hiding/Unhiding Fields;
- Freezing Fields;
- Adding Total Rows;
- Deleting Tables.
Table Design
- Modifying the Table Design;
- Field Names;
- Field Size Property;
- Number Property;
- Decimal Places Property;
- Format Property;
- Smart Tags;
- Show Date Picker;
- Input Mask Property;
- Caption Property;
- Validation Rules;
- Required and Allow Zero Length;
- Indexing Fields
- Setting a Primary Key;
- Changing Field Order;
- Saving Design Changes;
- Adjusting Column Widths.
Table Relationships
- Table Relationships;
- Selecting the Tables;
- Creating Relationships;
- Referential Integrity;
- Relationship Line;
- Editing Relationships;
- One to One Relationships;
- Removing Relationships;
- Hiding/Showing Tables;
- Many-to-Many Relationships;
- Creating Link Tables.
Importing Data
- Importing Data into Access;
- Import Options;
- Importing from Access Database;
- Appending Imported Data;
- Importing from Excel Spreadsheet;
- Creating Linked Tables;
- Updating Linked Tables.
Access Options
Modifying Options
- Access Options;
- General Options;
- Current Database Options;
- Datasheet Options;
- Object Designer Options;
- Proofing Options;
- Language Options;
- Client Settings Options;
- Customize Ribbon Options;
- Quick Access Toolbar Options.