Placeholder image

Microsoft Access Courses

Microsoft Access

Gloria K offers both beginning and intermediate/ advanced courses in Microsoft Access. These courses may be taken individually, but many of our students take both levels.

We offer group as well as one-on-one training. Class sizes are small (usually 5 or 6 students). Our facility is located in Lake Success, NY.

Microsoft Access Beginning

This course is designed for those that want to learn Access from the start or refresh a basic knowledge of the program. Even with some familiarity with Microsoft Access, there is always something new to be learned or techniques can be improved from taking our Access Beginning course.

Course Outline:

  • Create a New Blank Database (more)
  • Add Records to a Table (more)
  • Rename Table Fields in Datasheet View
  • Modify the Design of a Table
  • Add a Second Table to a Database
  • Create and Use a Query, Form, and Report (more)
  • Create a Database Using a Template
  • Organize Database Objects in the Navigation Pane
  • View a Report and Print a Table in a Database Created with a Template
  • Create Table Relationships (more)
  • Sort Records in a Table
  • Create a Query in Design View
  • Create a New Query from an Existing Query
  • Sort Query Results
  • Specify Criteria in a Query
  • Importing an Excel Spreadsheet
  • Specify Numeric Criteria in a Query
  • Use Compound Criteria
  • Create a Query Based on More Than One Table
  • Use Wildcards in a Query
  • Use Calculated Fields in a Query
  • Group Data and Calculate Statistics in a Query
  • Create a Form
  • Use a Form to Add and Delete Records
  • Create a Form by Using the Form Wizard
  • Modify a Form in Design View and in Layout View
  • Filter Records
  • Create a Report by Using the Report Tool , Blank Report tool and Wizard
  • Modify the Design of a Report
  • Print a Report and Keep Data Together
  • Microsoft Access Intermediate/Advanced

    This course is for students that are already comfortable with their basic knowledge of Access and want to take their knowledge to the next level.

    Course Outline:

    • Customize Table Fields
    • Structure Data Input
    • Validate Data Input
    • Create Indexes and Change Sort Order
    • Create Relationships between Tables
    • Create Forms and Reports with Related Tables
    • Create Forms with Subforms
    • Create Forms with Special Views
    • Build a Form in Design View
    • Use Advanced Formatting Tools
    • Build Reports Based on Queries
    • Export a Report and Create a Labels Report
    • Create a Subreport Using Design Tools
    • Summarize Report Data
    • Create a Report with an Interactive Filter

    Fill out the form below and click submit

    Instead of the form, I would rather:

    About Us

    Gloria K is a NYS Licensed computer training center centrally located in Nassau County, Long Island, NY. We offer corporate training and training to individuals. Our class sizes are small, typically fewer than eight students. All of our courses are taught with a live instructor. Each student sits at their own computer in a modern setting. We offer additional courses in Microsoft Office, such as Word, Excel, PowerPoint, Access and Outlook, and we also offer a QuickBooks course.

    We are centrally located on Long Island, serving Nassau, Suffolk and Queens. We serve many communities, some of which include, but not limited to, Mineola, Westbury, Great Neck, Manhasset, Roslyn, Franklin Square, Garden City, Hicksville, Little Neck, Williston Park, New Hyde Park, Levittown, Bellmore, Massapequa, Huntington, Bayside, and Douglaston.

    Contact Us

    Gloria K School
    1979 Marcus Avenue, Ste C100

    Lake Success, NY 11042
    P: (516) 482-2323