| |
| |
| |
| Storing the Putts for Paws Golf Tournament Data in a Database | |
| |
| |
| Prepare Workshop 1: Understanding the Putts for Paws Main Database Objects | |
| |
| |
| Understanding Database Basics and Tables | |
| |
| |
| What is Access? | |
| |
| |
| What are the Four Main Objects in a database? | |
| |
| |
| Creating a new database and templates | |
| |
| |
| Maneuvering in the Navigation Pane | |
| |
| |
| Ways to view the objects | |
| |
| |
| Shutter Button | |
| |
| |
| Customizing the navigation pane | |
| |
| |
| Enabling the Search Box | |
| |
| |
| File Extensions in Access | |
| |
| |
| Introducing Tables | |
| |
| |
| What is a table? | |
| |
| |
| Import a table | |
| |
| |
| Navigate through the table | |
| |
| |
| Difference between Access and Excel | |
| |
| |
| Discovering a Database (Manual Query) | |
| |
| |
| Understanding Queries, Forms, and Reports | |
| |
| |
| Introducing Queries | |
| |
| |
| Creating a Query using Wizard | |
| |
| |
| Selecting a value using Design View | |
| |
| |
| Printing Query Results | |
| |
| |
| Introducing Forms | |
| |
| |
| Creating a Form | |
| |
| |
| Entering data via a Form | |
| |
| |
| Introducing Reports | |
| |
| |
| What is a Report? | |
| |
| |
| Creating a Report using Wizard | |
| |
| |
| Printing Report Results | |
| |
| |
| Backing up your Database | |
| |
| |
| Compact and Repair | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Prepare Workshop 2: Gathering the Putts for Paws Data into the Database | |
| |
| |
| Inserting Data into a Database | |
| |
| |
| Database Design | |
| |
| |
| Automated Mechanisms for Data Acquisition | |
| |
| |
| Copy and Pasting | |
| |
| |
| Importing (.accdb, .xlsx, .csv, & .txt) | |
| |
| |
| Manual Data Entry | |
| |
| |
| Entering Data via Data Sheet view | |
| |
| |
| Removing Data | |
| |
| |
| Understanding Tables and Keys | |
| |
| |
| Creating a table in design view | |
| |
| |
| Data types (Text, Memo, Number, Currency, Yes/No, and Date/Time) | |
| |
| |
| Field Size | |
| |
| |
| Formatting | |
| |
| |
| Input Masks | |
| |
| |
| Understanding and Designating Keys | |
| |
| |
| Primary Keys | |
| |
| |
| Foreign Keys | |
| |
| |
| Composite Keys | |
| |
| |
| Natural v. Numeric Keys | |
| |
| |
| Understanding Relational Databases | |
| |
| |
| Understanding Basic Principles of Normalization | |
| |
| |
| Entities, Entity Classes, & Attributes | |
| |
| |
| Redundancy minimization | |
| |
| |
| Understanding and Creating Relationships | |
| |
| |
| Utilizing the Relationships Window | |
| |
| |
| Relationship Types | |
| |
| |
| One-to-many | |
| |
| |
| Adding a foreign key | |
| |
| |
| Forming the relationship | |
| |
| |
| Populate the foreign key | |
| |
| |
| Using two related tables in a report | |
| |
| |
| Many-to-many | |
| |
| |
| One-to-one | |
| |
| |
| Understanding Referential Integrity | |
| |
| |
| Cascade Update | |
| |
| |
| Cascade Delete | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Module Capstone | |
| |
| |
| More Practice 1 | |
| |
| |
| Problem Solve 1 | |
| |
| |
| Problem Solve 2 | |
| |
| |
| Problem Solve 3 | |
| |
| |
| Perform in Your Life | |
| |
| |
| Perform in Your Career 1 | |
| |
| |
| Perform in Your Career 2 | |
| |
| |
| How Others Performed | |
| |
| |
| |
| Organizing the Storage of Turquoise Oasis Spa's Transactions | |
| |
| |
| Prepare Workshop 3: Organizing the Storage of Spa Transactional Data | |
| |
| |
| Understanding Relational Databases | |
| |
| |
| Identifying the Advantages of the Relational Database over the Flat File database | |
| |
| |
| Understanding Basic Principles of Normalization | |
| |
| |
| Entities, Entity Classes, & Attributes | |
| |
| |
| Redundancy minimization | |
| |
| |
| Understanding and Creating Relationships | |
| |
| |
| Utilizing the Relationships Window | |
| |
| |
| Relationship Types | |
| |
| |
| Many-to-Many | |
| |
| |
| One-to-Many | |
| |
| |
| One-to-One | |
| |
| |
| Understanding Referential Integrity | |
| |
| |
| Cascade Update | |
| |
| |
| Cascade Delete | |
| |
| |
| Enforcing | |
| |
| |
| Evaluating Transactions at the Spa | |
| |
| |
| Finding data on using datasheet view | |
| |
| |
| Find feature | |
| |
| |
| Find with wildcards | |
| |
| |
| Simple Query Wizard and the limitations | |
| |
| |
| Creating a Multi-tabled Query using Design View | |
| |
| |
| Understand which tables to add to the view | |
| |
| |
| Adding Basic Criteria (Exact Match, Basic Operators, & AND/OR) | |
| |
| |
| Adding a simple Calculated Field using the Builder | |
| |
| |
| Adding Sum, Min, Max, & Average aggregation | |
| |
| |
| Using Other Query Wizards | |
| |
| |
| The Find Unmatched Query Wizard | |
| |
| |
| Using the wizard | |
| |
| |
| Understanding why the simple query wizard is unable to find this data | |
| |
| |
| Find Duplicates Query Wizard | |
| |
| |
| Cross tab query wizard | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Prepare Workshop 4: Developing a User Interface for Spa Transactions | |
| |
| |
| Creating Forms using the Form Wizard | |
| |
| |
| Moving and resizing controls | |
| |
| |
| Adding a subform on a tab control | |
| |
| |
| Enhancing with Conditional Formatting | |
| |
| |
| Navigating forms | |
| |
| |
| Printing forms | |
| |
| |
| Creating Reports using the Report Wizard | |
| |
| |
| Setting Printing Options | |
| |
| |
| Grouping & Sorting | |
| |
| |
| Adding Subtotals | |
| |
| |
| Printing Reports | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Module Capstone | |
| |
| |
| More Practice 1 | |
| |
| |
| Problem Solve 1 | |
| |
| |
| Problem Solve 2 | |
| |
| |
| Problem Solve 3 | |
| |
| |
| Perform in Your Life | |
| |
| |
| Perform in Your Career 1 | |
| |
| |
| Perform in Your Career 2 | |
| |
| |
| How Others Performed | |
| |
| |
| |
| The Red Bluff Golf Club Pro Shop, Advanced Tables and Queries | |
| |
| |
| Prepare Workshop 5: Advanced Tables | |
| |
| |
| Controlling the Way Data is Entered | |
| |
| |
| Advanced Field Options | |
| |
| |
| Using Input Masks | |
| |
| |
| Defining Input Masks | |
| |
| |
| Using the Input Mask Wizard | |
| |
| |
| Using Custom Formatting | |
| |
| |
| Defining Data Validation Rules | |
| |
| |
| Working with Captions | |
| |
| |
| Creating Indexes | |
| |
| |
| Defining a Single Field Index | |
| |
| |
| Defining Multiple Field Indexes | |
| |
| |
| Requiring Data Property | |
| |
| |
| Advanced Data Types | |
| |
| |
| Creating Lookup Fields | |
| |
| |
| Using the Lookup Field Wizard | |
| |
| |
| Lookup Field Properties | |
| |
| |
| Calculated Data Type | |
| |
| |
| Yes/No Data Type | |
| |
| |
| Autonumber (and preference for natural keys) | |
| |
| |
| Attachments, Hyperlinks, and OLE Objects | |
| |
| |
| Filtering Data | |
| |
| |
| Using the Table Analyzer Wizard | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Prepare Workshop 6: Utilizing Queries to Retrieve Business Data | |
| |
| |
| Advanced Criteria & Calculations | |
| |
| |
| Using Wildcard Characters in String Comparisons | |
| |
| |
| LIKE Function | |
| |
| |
| Wildcard Characters | |
| |
| |
| Find Records with the "Most" or "Least" Values | |
| |
| |
| Top Values | |
| |
| |
| Make a Query Ask for Input | |
| |
| |
| Using Parameters in a Query | |
| |
| |
| Specify Parameter Data Types | |
| |
| |
| Concatenate Function | |
| |
| |
| Not, In and Other Advanced Operators | |
| |
| |
| Advanced Functions in Queries | |
| |
| |
| If Functions | |
| |
| |
| Basic If Function for Individual Condition | |
| |
| |
| Nested If Functions for Various Conditions | |
| |
| |
| IsNull Function | |
| |
| |
| Working with Fields that Contain No Valid Data | |
| |
| |
| Dates | |
| |
| |
| Date versus Now Function | |
| |
| |
| Use DateDiff to Determine a Time Interval | |
| |
| |
| Use DateAdd to Subtract a Time Interval | |
| |
| |
| Use DateSerial to Return a Date (Year, Month, and Day) | |
| |
| |
| Use DatePart to Evaluate a Date | |
| |
| |
| Round | |
| |
| |
| Rounding to a Specific Number of Decimal Places | |
| |
| |
| Distinguishing Between Rounding and Formatting | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Module Capstone | |
| |
| |
| More Practice 1 | |
| |
| |
| Problem Solve 1 | |
| |
| |
| Problem Solve 2 | |
| |
| |
| Problem Solve 3 | |
| |
| |
| Perform in Your Life | |
| |
| |
| Perform in Your Career 1 | |
| |
| |
| Perform in Your Career 2 | |
| |
| |
| How Others Performed | |
| |
| |
| |
| The Turquoise Oasis Spa, Advanced Calculations and Action Queries | |
| |
| |
| Prepare Workshop 7: Creating Business Information Using Aggregation with Advanced Calculations | |
| |
| |
| Understanding the GROUP BY Clause in Aggregated Calculations | |
| |
| |
| Calculating Sales Volume | |
| |
| |
| Using GROUP BY to Summarize Duplicate Data | |
| |
| |
| Understanding the WHERE Clause in Aggregated Calculations | |
| |
| |
| Calculating Sales Revenue | |
| |
| |
| Business Calculations Using Sub-Querying | |
| |
| |
| Creating a Query on a Query | |
| |
| |
| Calculating the Percentage of Sales Revenue | |
| |
| |
| Calculating the Percentage of Sales Volume | |
| |
| |
| Calculating Physical Volume | |
| |
| |
| Calculating the Percentage of Physical Volume | |
| |
| |
| Understanding Structured Query Language | |
| |
| |
| SELECT Statement Basics | |
| |
| |
| Viewing SQL Statements | |
| |
| |
| Creating a Basic SQL Query | |
| |
| |
| Using the WHERE Clause | |
| |
| |
| Using the HAVING Clause with AS and GROUP BY | |
| |
| |
| Creating a Union Query | |
| |
| |
| Creating a SQL Sub-query | |
| |
| |
| Creating a Crosstab Query | |
| |
| |
| Crosstab Query Wizard | |
| |
| |
| Editing a Crosstab Query | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Prepare Workshop 8: Action Queries and Advanced Relationships | |
| |
| |
| Understanding Action Queries | |
| |
| |
| Creating a New Table | |
| |
| |
| Creating a Make Table Query | |
| |
| |
| Running a Make Table Query | |
| |
| |
| Adding Data to a Table | |
| |
| |
| Creating an Append Query | |
| |
| |
| Running an Append Query | |
| |
| |
| Editing and Deleting Data | |
| |
| |
| Creating, Testing and Running Update Queries | |
| |
| |
| Simple Update Queries | |
| |
| |
| Complex Update Queries | |
| |
| |
| Creating, Testing and Running Delete Queries | |
| |
| |
| Simple Delete Queries | |
| |
| |
| Complex Delete Queries | |
| |
| |
| Advanced Relationships Using Multiple Tables | |
| |
| |
| Creating Inner Joins | |
| |
| |
| Creating Outer Joins | |
| |
| |
| Unmatched Query Wizard | |
| |
| |
| EOW: Practice Problem 1 | |
| |
| |
| EOW: Practice Problem 2 | |
| |
| |
| Module Capstone | |