MS Access 2013/2016 Introduction Course Information
Duration: Two Day: 9am – 4:30pm Price: $800
Software and Version | Course Length | May 2022 | June 2022 | July 2022 | August 2022 | September 2022 | October 2022 | November 2022 |
---|---|---|---|---|---|---|---|---|
Access 2013/2016 Introduction | 2 Day Course | 6 & 13 May | 7 & 14 June | 1 & 8 July | 2 & 9 August | 5 & 12 September | 6 & 13 October | 4 & 11 November |
Course Booking
Target Audience & Purpose
Access Introduction is for people new to databases, & for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate & Advanced courses.
Objectives
By the end of this course participants should be able to:
- Design and create a database
- Create tables and set the primary key
- Define the fields and properties for a table
- Enter data and modify the layout of a table
- Find data in tables
- Create queries
- Create table relationships
- Design and create forms and reports
- Print reports
Course Inclusions
- Comprehensive learning materials incl. exercise files
- Post course telephone support
- ‘Certificate of Attendance’
on completion of course - Morning & afternoon tea
Course Prerequisites
Participants should already:
- Be competent in using a mouse and keyboard
- Have an understanding of Windows
MS Access 2013/2016 Introduction Course Content
Exploring Access
Start Access, Open & Close a Database, Use the Ribbon, Use the Contextual Tabs, Use Toolbar, Use Database Objects, Use Navigation Pane, Open a Database Object, Use & Close All Tabbed Documents, Use the Status Bar, Use the Options Dialog Box, Exit Access
Creating Tables
Use Database Templates, Create a Database, Design Tables, Create a Table in Datasheet View, Create a Table in Design View, Add Field Names, Assign Data Types, Save a Table, Add a Field Description, Set a Primary Key, Use Multi-valued Fields
Working with Tables
Use Datasheet View, Navigate Fields in Tables, Add & Move through Records, Select, Editing, Save, Delete Records
Editing Tables
Change Row Height & Column Width, Change Font Attribute, Change Cell Effect, Use Alternate Background Colors, Select, Move, Hide, Unhide & Freeze a Column
Finding & Filtering Data
Sort Records, Find Specific Records, Find Records using Wildcards, Use Replace, Use Filter By Selection, Apply/Remove a Filter, Use Filter Exclude Selection, Use the Search Box, Use Quick Filter, Use AutoFilter
Printing Data
Change Page Setup, Use Print Preview, Print Selected Records
Creating Relationships
Use Related Tables, Create a Relationship between Tables, Set Referential Integrity, View Subdatasheets, Delete a Join Line
Using Simple Queries
Use Queries & Recordsets, Simple Query Wizard, Create Query in Design View, Open a Query, Add a Table, Join Tables, Run a Query
Modifying Query Results
Sort a Query, Add Criteria to a Query, Hide a Field in a Query, Display a Totals Row in a Query, Add a Record using a Query, Print a Query
Creating Basic Forms
Use Form Button, Add a Record using a Form, Use the Calendar for Date Picking, Use the Form Wizard, View Records in a Form, Print Records in a Form, Base a Form on a Query
Creating Basic Reports
Use Report Button, Use Print Preview, Print Pages of a Report, Report Wizard, Change Views in a Report, Group & Summarize Report Data, Base a Report on a Query
Modifying Tables
Insert a Column into a Table, Insert a Lookup Column, Insert a Hyperlink Column, Create a Many-to-Many Relationship
Setting Field Properties
Limit Field Size, Set Number Formats, Set Date/Time Formats, Setting Yes/No Formats, Set Default Values, Set Validation Rules, Create an Input Mask – Wizard, Create an Input Mask Manually, Create a Custom Input Mask, Lookup List, Modify Lookup Properties
Using Operators in Queries
Use Comparison Operators, Use an & Condition, Use an Or Condition, Use the Between & Operator, Use a Wildcard Character
Designing Advanced Queries
Set Top Values in a Query, Create a Calculated Field, Format a Calculated Field, Create a Function Query, Create a Parameter Query, Multivalued Fields, Create a Concatenation in a Query, Filter a Query
Using Advanced Query Wizards
Use the Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard
Manipulating Form Controls in Design View
Select, Delete, Size Controls, Set Control Margins & Padding, Hide the Ruler, Disable Snap to Grid Feature, Display Field List, Add a Field, Move Part of a Paired Control, Align & Space Controls
Using Design View
Add a Label, Add an Image, Add a Rectangle, Add a Line, Edit an Unbound Control, Use Multiple Undo/Redo in Design View
Using Editing Tools
Change the Font, Change Character Format, Change Fill & Background Colors, Format Lines & Borders, Apply Special Effects, Conditional Formatting, Use Format Painter, Use AutoFormat, Use Error Checking, Run Spelling Checker, Set AutoCorrect Options, Add AutoCorrect Entries
Using Advanced Form Design
Use Forms in Design View, Create a Combo Box, Edit List Items, Create a List Box, Create an Option Group, Add a Logic Control, Set the Tab Order Automatically, Set the Tab Order Manually, Add a Form Header & Footer, Create a Blank Form
Using Advanced Report Design
Add Report Sections in Design View, Create a Calculated Control, Create a Running Summary, Insert a Date/Time Control, Insert a Page Break, Chang the Report Margins, Use the Label Wizard, Create a Report without Using a Wizard
Forrest Training
Roving one-on-one trainer
Microsoft Office Courses
- Windows 10 Training
- Computer Fundamentals Course
- Microsoft Access Training
- Microsoft Excel Training
- Microsoft Office Training Schedule
- Microsoft Office Upgrade Training
- Microsoft OneNote Training
- Microsoft Outlook Training
- Microsoft PowerPoint Training
- Microsoft Project Training
- Microsoft Publisher Training
- Microsoft Visio Training
- Microsoft Word Training
Microsoft Training & Certification
Desktop – Non Microsoft Courses
Professional Development Courses
- Business Etiquette Training
- Change Management Training
- Creative Problem Solving Training
- Customer Service Training
- Effective Business Writing Training
- Effective Communication Skills Training
- Leadership and Influence Training
- Management Fundamentals Training
- Negotiation Skills Training
- Presentation Skills Training – Presenting with Confidence
- Project Management Training
- Time Management Training