ACCESS 2013 Basic Level

• Starting and Closing Access
• Identifying Tabs
• Ribbons
• The Quick Access Toolbar and Locating the Backstage
• Identifying Account Information and Switching Users
• Opening Existing and Recently Used Databases
• Identifying the Primary Access Objects: Tables, Queries, Forms & Reports
• Exploring the Different Access Views
• Understanding Five Essential Steps for Database Design
• Creating a New Database
• Getting Help

Learning the Essential Access Building Blocks – Tables

• Creating Tables
• Identifying Data Types
• Setting Basic Properties: Field Size, Format, Caption and Default Value
• Setting Additional Properties: Required, Allow Zero Length, Indexed and Others
• Controlling Data Using Input Masks
• Establishing a Primary Key
• Creating Table Relationships
• Establishing Referential Integrity
• Identifying Table Relationship Types

Working with Access Data

• Entering Table Data
• Deleting and Changing Records
• Using Find, Replace and Go To Features
• Sorting and Filtering Records
• Modifying Tables: Rename, Copy, Delete, Save As
• Viewing Data from Related Tables

• Introducing Queries
• Creating a Select Query Using the Wizard
• Building a Select Query in Design View
• Adding Criteria to a Query
• Asking And/or Questions
• Using Wildcards to Find Data
• Setting Query Properties

Designing Forms

• Using an Access Form
• Creating a Form Using the Form Wizard
• Creating a Form
• From Scratch
• Improving a Form Using the Form Design Tools
• Adding a Calculated Field
• Looking at Form Properties
• Using the Data Entry Property

Generating Reports

• Viewing an Access Report
• Creating an Access Report From Scratch
• Creating an Access Report Using the Wizard
• Looking at Report Properties
• Applying a Theme to a Report
• Preparing a Report for Print
• Making Changes to a Report