Microsoft Access (Level 1 / Basic)

Learn to use Microsoft Access to manage your data, construct tables, design forms and reports, and more. Microsoft Office Access® 2016 can help you and your organization collect and manage large amounts of data.

You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. In this course, you will use Access to manage your data by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

What You'll Learn

In this course, you will learn how to use Access to manage your data by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Course Outline

• What is access? What is a database?

• What are the related tables?

• Database Concept

• Getting Started Screen

• Opening a database and Exploring Environment (blank-template-existing)

• Differences from Excel: Similarities with PowerPoint

• Getting Help

• How do I plan a database?

• Explore tables in datasheets and design views

• Creating tables in Datasheet viewCreating tables in design View

• Changing the Design of a Table

• Effective and ineffective field names

• Deleting, inserting and Moving Fields

• Attachment Data Type

• Add a total row.

• Finding and Editing Records

• Sorting records

• Filtering a table

• Setting Field Properties

• Working with Input Masks

• Setting Validation Rules

• What is a query?

• Create Queries using a Wizard

• Creating and Using in Design view

• Modifying Query Results and Queries

• Performing Operations in Queries

• What is a form?

• Form Views

• Creating Forms by using form Button

• Creating Forms by using the Wizard

• Using Design View to create a form

• Sorting and Filtering Records in a form

• What is a report?

• Different views of a Report

• Change default view

• How to create a report by using the wizard

• Create a Report in Design view

• Sections of a report: Properties

• Grouping feature in Reports

• Modifying and printing reports