Microsoft

MS Access – Essentials

Getting Started

« Opening a database
« Tables
« Queries
« Forms
« Reports
« The interface

Designing a Relational Database

« Relational databases
« Relationship guidelines
« Fields and tables
« Primary keys, foreign keys, and composite keys
« Table relationships
« Relationship types
« Rules of normalization

Working with Tables and Records

« Navigate through records
« Add new records
« Sort and filter data
« Datasheet totals
« Subdatasheets
« Print records

Creating Tables

« Table views
« Data types
« Insert fields
« Move, edit, and delete fields
« Table properties
« Field captions
« Input masks

Creating Table Relationships

« The relationships window
« Referential integrity
« Edit relationships
« Join lines
« Relationships report

Creating Queries

« Simple query wizard
« Create a query
« Types of queries
« Query views
« Sort queries
« Multi-table queries
« Query criteria
« Comparison operators
« Logical operators

Creating Advanced Queries

« Parameter queries
« Wildcards in a parameter query
« Query joins
« Group query results
« Add calculated fields
« Arithmetic operators
« Subqueries
« Find duplicates query wizard
« Find unmatched query wizard
« Crosstab queries
Creating Forms
« Forms wizard
« Form views
« Form sections
« Add controls to forms
« Form design tools
« Field list pane

Creating Reports

« Report wizard
« Report views
« Report sections
« Add controls to reports
« Report design tools
« Group and sort reports
« Add background images to reports
« Format reports
« Include charts in a report
« Add a calculated field to a report
« Add a sub-report to an existing report
« Add headers and footers

Sharing Data Across Applications

« Import data into access
« Export data to excel
« Create a mail merge

superadmin

Share
Published by
superadmin

Recent Posts

Microsoft Planner

With Planner you and your team can to create plans, assign tasks, chat about tasks,…

4 weeks ago

Redesigning a Better Life

Redesigning a Better Life is about creating your own unique path and living a more…

2 years ago

Adobe Premiere Pro – Quickstart

Creating short videos is becoming an indispensable skill. In this one-day workshop, you will learn…

2 years ago

Project Management Quickstart

In this introductory course, students learn all of the basics of project management. Perfect for…

3 years ago

MS Sharepoint – Users

In this hands-on course, we will demonstrate and practice the essential skills you need to…

9 months ago

Document Design in Word

A well-designed document reflects well on you because a good page layout makes any document…

3 years ago