Access 2013 - Level 1 New Horizons Singapore

    Course details

    In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. 

    What will I learn?

    Lesson 1: Getting Started with Access 2013

    • Orientation to Microsoft Access
    • Create a Simple Access Database
    • Get Help in Microsoft Access

    Lesson 2: Working with Table Data

    • Modify Table Data
    • Sort and Filter Records
    • Create Lookups

    Lesson 3: Querying a Database

    • Join Data from Different Tables in a Query
    • Sort and Filter Data in a Query
    • Perform Calculations in a Query

    Lesson 4: Creating Advanced Queries

    • Create Parameter Queries
    • Create Action Queries
    • Create Unmatched and Duplicate Queries
    • Summarize Data

    Lesson 5: Generating Reports

    • Create a Report
    • Add Controls to a Report
    • Enhance the Appearance of a Report
    • Prepare a Report for Print

    Lesson 6: Customizing the Access Environment

    • The Access Options Dialog Box

    Lesson 7: Designing a Relational Database

    • Relational Database Design
    • Create a Table
    • Create Table Relationships

    Lesson 8: Joining Tables

    • Create Query Joins
    • Join Tables That Have No Common Fields
    • Relate Data within a Table
    • Work with Subdatasheets
    • Create Subqueries

    Lesson 9: Organizing a Database for Efficiency

    • Data Normalization
    • Create a Junction Table
    • Improve Table Structure

    Lesson 10: Sharing Data Across Applications

    • Import Data into Access
    • Export Data to Text File Formats
    • Export Access Data to Excel
    • Create a Mail Merge

    Lesson 11: Advanced Reporting

    • Organized Report Information
    • Format Reports
    • Include Control Formatting in a Report
    • Add a Calculated Field to a Report
    • Add a Subreport to an Existing Report

    Prerequisites

    Students should be familiar with using personal computers and have used a mouse and keyboard. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computer. Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. 

    Updated on 08 November, 2015

    About New Horizons Singapore

    Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

    See all New Horizons Singapore courses
    Are you from New Horizons Singapore ? Claim your course!
    Courses you can instantly connect with... Do an online course on Microsoft Access starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or