Access 2013 Lesson List

Chapter 1 : Author Mentoring

- Audience for this Course

- Job Roles and Employment Opportunities

- Prerequisite Knowledge and Skills

Chapter 2 : Fundamentals

- An Overview of Microsoft Access 2013

- Course Objective

- System Requirements

- Installing Microsoft Access 2013

Chapter 3 : Explore Microsoft Access 2013

- New Features of Access 2013

- Understanding Access 2013 User Interface

- Working with the Ribbon

- Using Help Option

Chapter 4 : Dealing with Databases

- What is a Database?

- Understanding Database Types

- An Overview of Database Objects

- Understanding Normalization

- Describing the Relationships

- An Overview of Database Objects

- Creating Databases From Templates

- Working with Web Databases

Chapter 5 : Working with Tables

- Access 2013 Data Types

- Creating a Database Table

- Manipulating Table Description

- Exploring Field Properties

- Handling with Rows

Chapter 6 : Data Format Restriction

- Using Constraints

- Data Restriction With Input Mask

- Data Validation Part I

- Data Validation Part II

- Working with Lists

Chapter 7 : Playing with Queries

- What is a Database Query?

- Creating Queries using Wizard

- Working with Manual Queries

- Summarizing the Data using Queries

- Perform Calculation Through Queries

- Using Update and Delete Queries

- Understanding Join and Union Queries

- Using TOP and Append Queries

- Filters and Distinct Queries

Chapter 8 : Forms

- Understanding Controls

- Types of Forms

- Creating a Simple Form with Form Tool

- Formatting the Form

- Working with Layouts

Chapter 9 : Data Extracting using Reports

- Creating Reports using Wizard

- Customizing the Reports

- Adding Sub Reports

- Adding Form Controls in the Reports

- Preview and Print Options

Chapter 10 : Communicating with External World

- Importing From Other Access Databases

- Extracting From Excel

- Import Data From Text Files

- Importing From HTML and XML Data

- Export to Excel and Word Applications

- Exporting to PDF and XPS Files

Chapter 11 : Making Databases Uses Friendly

- Designing Navigation Forms

- Creating Custom Categories

- Controlling Default Features

Chapter 12 : Protecting Databases

- Assigning Passwords to Databases

- Splitting Databases

- Packaging and Signing Databases

- Prevent Database Issues

Chapter 13 : Dealing with Global Settings

- Understanding Default Settings

- Using Add-ins

- Customizing the Ribbon

- Manipulating the Quick Access Toolbar

- Customizing the Status Bar