Full-Day Microsoft Access Intermediate



Microsoft Access Intermediate Relationships, Query, Form and Reports

Microsoft Access Intermediate Course Summary

Access database administrators that have database creation skills need in-depth knowledge of Relationships, Queries, Forms and Reports. Relationships between tables will include Reverential Integrity to make sure errors between tables do not occur. Queries are the source for Forms and Reports. A Query will find and generate the data needed and the Form or Report will format it and make it look presentable. We will cover different ways to generate a Query using wild characters, filters, operators, expression builder, parameters, concatenation, and action queries.  We will also learn how to create a Form and customize its control properties. In the Reports section of the course, we will cover how to format, controls, Design View, and Report Wizard. This course will also cover how to customize database components, Export, Import and Link to other data sources

Course Outline:

Chapter 1 – Relational Integrity Databases

In this chapter, you will learn how to manipulate columns, Insert Hyperlinks, and create Many-To-Many Relationships.

Chapter 2 – Advanced Database Design

Data Normalization – This is a process of making a database conform to a list of standards called “Normal Forms” that help prevent problems (anomalies) and ensure the integrity of the database.

Chapter 3 – Export, Import and Linking Tables

In this chapter, you will learn how to Import data, Export data, and link data to an Access Table.

Chapter 4 – Operators in Queries

In this chapter, you will learn how to use Comparison OperatorsAnd conditionsOr conditions,Between AND OperatorExpression Builder, and Wildcard Character.

Chapter 5 – Advanced Queries

In this chapter, you will learn how to set Top Values in a query, create a Calculated Field, format aCalculated Field, display a Totals Row in a query, create a Function Query, create a Parameter Query, use Multivalued Fields, create a Concatenation in a query, and Filter a query.

Chapter 6 – Action, Crosstab, And Duplicate Queries

In this chapter, you will learn how to create a Make-Table QueryUpdate QueryAppend QueryDelete Query, use the Crosstab Query Wizard, the Find Duplicates Query Wizard, and use the Find Unmatched Query Wizard.

Chapter 7 – Form and Report Design

In this chapter, you will learn how to use ControlsControl LayoutsStacked LayoutTabular Layout, remove a control from a LayoutMove Controls, view the properties of an object, change a Control Property, select Non-Adjacent Controls, select Adjacent Controls, Delete Controls, size a control by dragging, size controls automatically, set Control Margins, set control Padding, hide the Ruler, disable the Snap to Grid Feature, display the Field List, add a field, add a field from another table, move part of a Paired Control, Align controls, and Space controls.

Chapter 8 – Advanced Form Design

In this chapter, you will learn how to use forms in Design View, create a Combo Box, edit List Items, create a List Box, create an Option Group, add a Logic Control, set the Tab Order automatically, set the Tab Order manually, form Header and Footer, and create a Blank Form.

Chapter 9 – Advanced Report Design

In this chapter, you will learn how to add report sections in Design View, create a Calculated Control,create a Running Summary, insert a Date/Time Control, insert a Page Break, change the Report Margins, use the Label Wizard, and create a report without using a wizard.