Microsoft Office Topic Lists

 

Customize your Microsoft Office Topics - Homepage

MS Access 2013 - Introduction


TOPIC DETAILS


Access 2013 Introduction

  • Understand Microsoft Access 2013
  • Start Access from the windows start screen
  • Start Access from the desktop
  • Understand the start screen
  • Create a new blank database
  • Understand the backstage view
  • Open an existing database file
  • Understand the Access 2013 screen
  • Use the ribbon
  • Work with the navigation pane
  • Add commands to the QAT
  • Work with touch mode
  • Work with a table
  • Work with other database objects
  • Close a database file
  • Exit from Access 2013

Designing A Lookup Database

  • Understand how Access stores data
  • Understand Access 2013 data types
  • Scope your new database
  • Identify table problems
  • Refine table structures
  • Finalise the design

Creating A Lookup Database

  • Create a new database file
  • Create the lookup table
  • Define the primary key
  • Save and close a table
  • Create the transaction table
  • Understand lookup table relationships
  • Connect to a lookup table
  • View table relationships

Modifying Table Structures

  • Open an existing table
  • Add fields to an existing table
  • Understand field properties
  • Change field size
  • Change field names
  • Change decimal places
  • Change date formats
  • Index fields
  • Delete fields from a table
  • Copy a table within a database
  • Delete a table from a database file

Adding Records To A Table

  • Type records in a table
  • Add records using a form
  • Save a form layout for reuse
  • Add records using an existing form
  • Assignment: adding records
  • Import from Microsoft Excel

Adding Transactional Records

  • Type records in a table
  • Add records using a form
  • Save a form layout for reuse
  • Add records using an existing form
  • Assignment: adding records
  • Import from Microsoft Excel

Working With Records

  • Table navigation
  • Navigate to a specific record
  • Edit a record
  • Delete record data
  • Undo a change
  • Delete a record
  • Delete several records
  • Search in a table
  • Search in a field
  • Find and replace
  • Print records from a table
  • Compact a database

Sorting And Filtering

  • Simple Sorting
  • Sort on several fields
  • Simple filter
  • Work with filters
  • Filter between dates

Creating Queries

  • Understand queries
  • Create a query design
  • Work with a query
  • Change a query design
  • Apply record criteria
  • Clear selection criteria
  • Save a query
  • Run queries from the navigation pane
  • Delete a query
  • Assignment: create queries

Creating And Using Reports

  • Understand reporting in Access
  • Create a basic report
  • Work with existing reports
  • Preview and print a report
  • Change the report layout
  • Use the report wizard
  • Create a grouped report
  • Create a statistical report
  • Work with grouped reports

Creating and Using Forms

  • Understand forms
  • Create a basic form
  • Create a split form
  • Bind a form to a query
  • Use the form wizard
  • Work with existing forms
  • Edit records in a form
  • Delete records through a form
  • Delete an unwanted form