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
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 Operators, And conditions, Or conditions,Between AND Operator, Expression 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 Query, Update Query, Append Query, Delete 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 Controls, Control Layouts, Stacked Layout, Tabular Layout, remove a control from a Layout, Move 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.