Easy Excel Learning

Juan Hinojosa, Technologist and Math Instructor

Category: Queries

  • Introduction to Access 6-28-2015

    Below is a link to the databases developed in class.

    Introduction to Access 06-28-2015

    Steps to access the databases in the zip file:

    1. Download the above zip file
    2. Right-click the “zip” file from step 1 above and select extract.
    3. Open the folder containing the extracted files.
    4. If you have Microsoft Access, the access files .accdb can be opened by double clicking the extracted file.

    You can use the extracted files to review:

    1. Tables
    2. Queries
    3. Relationships
    4. Sorting a table
    5. Filtering a table
    6. Sorting a query
    7. Filtering a query
    8. Creating a Form and Report

  • Introduction to Access 3-28-2015

    Below is a link to the two databases developed in class.

    VacationPlanning 03-28-2015

    To access the databases download the above zip file, right-click the “zip” file and select extract.

    You can use the files to review:

    1. Tables
    2. Queries
    3. Relationships
    4. Sorting with a table
    5. Filtering with a table
    6. Sorting with a query
    7. Filtering with a query
    8. Using formula in a query
    9. Creating a Form and Report

  • Introduction to Access 3-10-2015

    Below is a link to the two databases developed in class.

    Introduction to Access 3-10-2015

    To access the databases download the zip file and then right-click that “zip” file and select extract.

    You can use the files to review:

    1. Tables
    2. Queries
    3. Relationships
    4. Sorting with a table
    5. Filtering with a table
    6. Sorting with a query
    7. Filtering with a query

  • Introduction to Access 7-12-2014

    Below is a link to the three databases developed in class.

    Introduction to Access 7-12-2014

    To access the databases, download the zip file and then right-click that “zip” file to extract the files.

    You can use the files to review:

    • Tables
    • Queries
    • Relationships
    • Sorting with a table
    • Filtering with a table
    • Sorting with a query
    • Filtering with a query
    • The overview of reports and subforms

  • Introduction to Access 4-12-2014

    Below is a link to the database developed in class.

    Introduction to Access 4-12-2014

    To access the database, download the zip file and then right click that “zip” file to extract it.

    You can use this file to review:

    • Tables
    • Queries
    • Relationships
    • Sorting with a table
    • Filtering with a table
    • Sorting with a query
    • Filtering with a query

  • Introduction to Access 11-16-2013

    Below is a link to the database developed in class.

    Introduction to Access 11-16-2013

    To access the database, download the zip file and then right click that “zip” file to extract it.

    You can use this file to review:

    • Tables
    • Queries
    • Relationships
    • Sorting with a table
    • Filtering with a table
    • Sorting with a query
    • Filtering with a query
    • Data reconciliation between two sets
    • The quick preview of Reports and Forms

  • Introduction to Access 6-29-2013

    Below is a link to the database developed in class.

    Introduction to Access 6-29-2013

    To access the database, download the zip file and then right click that “zip” file to extract it.

    You can use this file to review:

    • Tables
    • Queries
    • Reports

  • Introduction to Microsoft Access 2010 (3-16-2013)

    I am pleased to announce that below is the link to the “Summer List” database developed in class.  It has been provided so you can practice the activities done in class. It contains tables, queries, a crosstab query, report, and data imported from Excel.

    To access the database:

    1. Download the zip file below.
    2. Open the folder containing the zip file from the previous step.
    3. Right click that zip file to extract it.
    4. Once the zip file is extracted, you should be able to open the database.

    Introduction to Access 3-16-13 Summer List

  • Introduction to Access 3-9-13 Summer List

    It was a pleasure working with the group. Below is a copy of the database developed during the workshop to practice the activities done in class.

    To access the database:

    1. Download the zip file below.
    2. Open the folder containing the zip file from the previous step.
    3. Right click that zip file to extract it.
    4. Once the zip file is extracted, you should be able to open the database.

    Introduction to Access 3-9-13 Summer List

  • Introduction to Access 10-21-2012

    It was a pleasure working with a very motivated group. I am excited to know that participants have requested a copy of the tables and queries developed during the workshop.

    To access the databases, you will need to download the zip file below: “Introduction to Access 10-21-2012 (two Access files)” and then right click that zip file to extract it.

    Link to zip file:
    Introduction to Access 10-21-2012 (two Access files)

  • Introduction to Access 7-8-2012

    It was a pleasure working with a very enthusiastic group today. I am excited to know many participants have inquired about the tables and queries developed during the workshop. Attached are the two databases. To access the databases, you will need to download the zip file: Introduction to Access 7-8-2012.zip and then right click that zip file to extract it.

    Introduction to Access 7-9-2012