Diane Bittle

Overview of CIS105 Introduction to Software

Overview of CIS135 Excel Course

Welcome to D2L 2024

File Explorer

Windows11 Desktop

SQL - Calculated fields & Parameters

SQL - WHERE & ORDER BY Clause

SQL - Select, From Clause

Download and upload project files in SIMnet

Insert, Delete, Move fields in design view.

Welcome to CIS140

Navigation Form in Access

Add Tab Controls to a Form

Normalization of Database

Primary & composite Key Fields

Join Properties

Many to Many Relationship - Lookup Wizard

Import Text File into Access Table

Importing Excel into Table

Tab Order, Scroll bar, Enable Data

Top, Left, Width, Align Properties in a Form

Date Functions in Queries

Make Table, Update, Delete, Append Queries

Group in Report & Conditional Formatting

Data Entry Property of Form

Command Button to Form

Aggregate functions in a Query

Calculated Fields in a Query

Relational Database

Validation Rule/Text for Records