Essential Database Concepts: Access Forms, Reports, and Relationships Q&A

Fundamental Database Structure and Functions

Database Relationships and Table Tools

Database Relationships: The Three Types

The three types of relationships that can be created are: one-to-one, one-to-many, and many-to-many.

Defining an Advanced Table

An advanced table is the fastest template that satisfies your needs when starting a database.

SUM vs. COUNT Aggregate Functions

The SUM function adds the numerical elements of a column, while the COUNT function counts the total number of elements (records) in a column.

Purpose of the Standard Deviation Function

The standard deviation function provides a measure of the dispersion or variability of data from the mean (average).

What is the Table Analyzer?

The Table Analyzer is an assistant that examines a table and asks a series of questions to determine if it should be divided (normalized) into two or more tables.

Ways to Create a Field

Fields can be created in different ways, depending on the database context and view.

Adding Fields in Datasheet View

Fields can be added in the Datasheet View, using a template, or by using an existing field from another table.

"Show Date Picker" Property Description

This property specifies whether Access displays a date picker (calendar control) when users edit a field value.

Tracking Field Value History: Append Only

The property used to track field value history is Append Only. Setting this property to Yes enables tracking. Changing this property back to No will erase the field value history.

Function of the Query Wizard

The Query Wizard is used to create a field via the query dialog box. This field often uses a combined box to search for a value in another table or list of values. Note: The Find Wizard is not a data type.

Working with Forms in Access

Defining a Simple Form

A simple form is automatically generated by Access from an active table, displaying the records added to that table. Access retrieves the information and presents it with an improved appearance in the form, allowing new information to be registered.

What are Form Tools?

Form Tools are used to quickly create a simple form containing the specific data fields you wish to display.

Views Provided by a Split Form

A split form provides two simultaneous views: a Form View and a Datasheet View.

Advantages of Using a Split Form

The main advantage of a split form is that it allows users to utilize both the Form View and the Datasheet View simultaneously.

Understanding Subforms

A subform is a form that is inserted within another form.

Naming Primary and Nested Forms

The primary form is typically called the Principal Form, and the nested form is called the Subform.

Creating and Customizing Reports

Defining a Complex Report

A complex report is a highly customizable report that allows you to modify and add numerous characteristics to adapt it precisely to the data being used and the intended purpose of the report.

The Role of the Report Wizard

The Report Wizard is the easiest way to create a report, especially when you need to selectively choose the fields to include.

Can the Report Wizard Include Multiple Fields?

Yes, the Report Wizard allows you to include fields from more than one table or query.