Access 2013 Core Essentials
Course Description
This one-level workshop covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more.
1 Day
€295.00
Prerequisites
Participants are expected to be IT literate. This is not an introduction to computers courseThe Basics
Getting StartedSigning In
Creating a Database
Database Terminology
Saving a Database
Opening a Database
Your First Database
About Security WarningsAbout Relationships
Searching for Objects
Opening Database Objects
Changing the Object View
Understanding the Types of Views Available
Managing Objects
Working with Tables and Records
Creating a TableUnderstanding Table Views
Adding and Editing Records
Searching and Browsing Records
Deleting Records
Printing Records
Formatting Tables
Selecting DataChanging Column and Row Width and Height
Applying Text Formatting
Applying Gridlines
Changing Fill Colors
Checking Your Spelling
Creating Forms
Creating a Form from an ObjectCreating a Form with the Wizard
Creating a Form from Scratch
Understanding Form Views
Using a Form
Formatting Forms
Understanding Bound and Unbound ControlsChanging the Theme
Using the Format Painter
Adding Fields
Adding Controls
Adding Images and Logos
Creating Reports
Creating a Report from an ObjectCreating a Report with the Wizard
Creating a Report from Scratch
Understanding Report Views
Printing Reports
Formatting Reports
Changing the ThemeUsing the Format Painter
Grouping and Sorting Data
Adding Controls
Adding Images and Logos
Adding Page Numbers, Headers, and Footers
Creating Basic Queries
Types of QueriesCreating a Query with the Wizard
Running a Query
Understanding Query Views
Sorting and Filtering a Query
Creating Advanced Queries
Creating and Using Parameter QueriesCreating and Using Crosstab Queries
Creating and Using Make-Table Queries
Creating and Using Multiple Table Queries
Creating and Using Append Queries
Creating and Using Delete Queries
Creating and Using Update Queries
Managing Your Database
Compacting and Repairing a DatabaseEncrypting a Database with a Password
Backing Up Your Database
Exporting a Database and Database Objects
Printing Database Objects
Customizing the Interface
Collapsing and Pinning the RibbonCustomizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
AccessAccess 2013Microsoft AccessMicrosoft Access 2013MS Access