- Duration: 10 hours
Microsoft Access Foundation
This Foundation level course covers the skills that students will need to make the most of Microsoft Access. The course begins with the basics and progresses through several modules which cover databases, tables and records, relationship, and much more.
- How to identify database components
- How to start and examine Access
- How to Open a database
- How to Examine the database window, including using Help
- How to Plan and create a database
- How to Examine a table in Datasheet & Design views
- How to Add a field to a table and set the primary key
- How to Sort & filter records
- How to Set field properties
- How to Normalise tables, use the Table Analyser, & identify object dependencies
- How to Set relationships between tables
- How to Implement referential integrity
- How to Plan & print table relationships
The course begins with a look at how to get started with Access, create and save a database, and open an existing database. Then, participants will learn how to sign into Office with a Microsoft account. The module also includes information on database terminology.
- Getting Started
- Signing In
- Creating a Database
- Database Terminology
- Saving a Database
- Opening a Database
This final module looks at the interface and tips for customizing it. Students are shown how to collapse and pin the ribbon, customize the Quick Access toolbar, hide and show ribbon tabs, create custom tabs, and reset changes made to the interface.
- Collapsing and Pinning the Ribbon
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tabs
- Resetting Interface Changes
This module discusses how to search for objects along with how to open various database objects. Students will also learn how to change object views and how to manage objects. Also included is information on security warnings and data relationships.
- About Security Warnings
- About Relationships
- Searching for Objects
- Opening Database Objects
- Changing the Object View
- Understanding the Types of Views Available
- Managing Objects
The third module takes a look at tables and records. Here, students will learn to create a table, add and edit database records, search and browse records, and delete and print records. How to make the most of different table views is covered here as well.
- Creating a Table
- Understanding Table Views
- Adding and Editing Records
- Searching and Browsing Records
- Deleting Records
- Printing Records
Delving deeper into tables is the focus of this module. In it, students will learn to select data, change the size of rows and columns, apply text formatting and fill color, apply gridlines, and perform a spell check.
- Selecting Data
- Changing Column and Row Width and Height
- Applying Text Formatting
- Applying Gridlines
- Changing Fill Colors
- Checking Your Spelling
In this module, topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks.
- Marking Fields as Required
- Marking a Field for Indexing
- Creating Lookup Fields
- Creating Value Lists
- Creating Input Masks
This opening module will show students how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Students also will learn about types of relationships and referential integrity
- Types of Relationships
- Viewing Relationships
- Viewing Object Dependencies
- What is Referential Integrity?
- Enforcing Referential Integrity
- Using Cascade Delete and Cascade Update
In this module, students are shown how to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.
- Inserting Application Parts
- Using the Table Analyzer Wizard
- Creating Validation Rules
- Configuring Validation Messages