- Duration: 10 hours
Microsoft Access Foundation
This intermediate level course will show how to get the most from this powerful database application. Learn to use the advanced features of Access to their full extent. By the end of this course, students will be able to create advanced queries to manipulate data, build advanced forms for efficient data entry, layout detailed reports.
Course Objectives
- How to create queries using the query wizard & design view
- How to sort & filter query results
- How to use comparison operators & calculations in queries
- How to create & modify forms
- How to create reports
- How to group & summarise data in a report
- How to print a report
- How to use the query wizard & design view to create joins
- How to master inner & outer joins
- How to create self-join queries
- How to find records that do not match between tables
- How to create calculated fields
- How to use the expression builder in queries
- How to create a query to display summary values
- How to master forms
Course Outlines
Description:
Forms are the topic discussed here. This module begins with the steps to create forms from an object. It then proceeds to looking at creating forms using the wizard. Students will also learn to create forms from scratch and how to use form views.
Main Points:
- Creating a Form from an Object
- Creating a Form with the Wizard
- Creating a Form from Scratch
- Understanding Form Views
- Using a Form
Description:
The look at forms continues in this module. Students will start the module by learning how to change the theme of a form. Also covered is how to use the Format Painter, add fields to a form, and add controls and images to a form.
Main Points:
- Understanding Bound and Unbound Controls
- Changing the Theme
- Using the Format Painter
- Adding Fields
- Adding Controls
- Adding Images and Logos
Description:
Reports are the focus of this particular module. First, students are shown how to create a report from an object and by using the wizard. Students will also learn how to create a report from scratch, use report views, and print reports.
Main Points:
- Creating a Report from an Object
- Creating a Report with the Wizard
- Creating a Report from Scratch
- Understanding Report Views
- Printing Reports
Description:
Information on reports is continued here with a look at how to change the theme of reports, use the Format Painter, and group and sort data in reports. The module also covers adding controls, images, logos, page numbers, headers, and footers to reports.
Main Points:
- Changing the Theme
- Using the Format Painter
- Grouping and Sorting Data
- Adding Controls
- Adding Images and Logos
- Adding Page Numbers, Headers, and Footers
Description:
This module allows students to develop skills on queries. They will learn how to create a query with the wizard, run a query, sort and filter a query, and use and apply query views. Students will also learn about the types of queries that are available.
Main Points:
- Types of Queries
- Creating a Query with the Wizard
- Running a Query
- Understanding Query Views
- Sorting and Filtering a Query
Description:
Getting a more in-depth look at queries is the goal of this module. Students will learn how to use parameter queries, multiple table queries, crosstab queries, make-table queries, append queries, delete queries, and update queries.
Main Points:
- Creating and Using Parameter Queries
- Creating and Using Crosstab Queries
- Creating and Using Make-Table Queries
- Creating and Using Multiple Table Queries
- Creating and Using Append Queries
- Creating and Using Delete Queries
- Creating and Using Update Queries
Description:
In this module, students will learn to compact and repair a database and encrypt a database using a password. Students are also shown how to back up a database, export a database and database objects, and print database objects.
Main Points:
- Compacting and Repairing a Database
- Encrypting a Database with a Password
- Backing Up Your Database
- Exporting a Database and Database Objects
- Printing Database Objects