Course Objectives
To give an introduction to database design concepts. This course offers a grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level.
Who Should Attend?
New User Microsoft Office Access 2013.
Pre-requisite
Basic knowledge on any Microsoft Operating System or basic user of any previous version.
Course Outlines
- Getting Started
- Creating a Database
- Database Terminology
- Saving a Database
- Opening a Database
- About Security Warnings
- About Relationships
- Searching for Objects
- Opening Database Objects
- Changing the Object View
- Understanding the Types of Views Available
- Managing Objects
- Creating a Table
- Understanding Table Views
- Adding and Editing Records
- Searching and Browsing Records
- Deleting Records
- Printing Records
- Selecting Data
- Changing Column and Row Width and Height
- Applying Text Formatting
- Applying Gridlines
- Changing Fill Colors
- Checking Your Spelling
- Creating a Form from an Object
- Creating a Form with the Wizard
- Creating a Form from Scratch
- Understanding Form Views
- Using a Form
- Understanding Bound and Unbound Controls
- Changing the Theme
- Using the Format Painter
- Adding Fields
- Adding Controls
- Adding Images and Logos
- Creating a Report from an Object
- Creating a Report with the Wizard
- Creating a Report from Scratch
- Understanding Report Views
- Printing Reports
- Changing the Theme
- Using the Format Painter
- Grouping and Sorting Data
- Adding Controls
- Adding Images and Logos
- Adding Page Numbers, Headers, and Footers