| Module 1 – Overview
of Relational Databases
What is a database?
What is a relational database?
Module 2 - Screen Layout
Overview of Ribbon and the Office Button
Understanding tabs, groups and commands
Using contextual tabs
Customize Ribbon
Add custom tabs and groups
Export a customized ribbon
Backstage View
Module 3 – Access Objects
Tables, Forms, Queries, Reports, Macros and
Modules
Module 4 - Tables
Creating a table in design view
Table structure: Field names and sizes
Data types
Field properties
Inserting fields
Look-up Lists
Indexes
Setting a Primary Key
Module 5 – Editing Data
Selecting fields and records
Adding and deleting records
Useful shortcut keys
Finding data
Find and replace
|
Module 6 – Relating
Tables
Overview: Why relate tables?
Types or relationship
One-to-one
One-to-many
Linking fields
The relationship window
Referential Integrity
Module 7 - Filters
Filtering in tables, Filter by selection
Exporting filtered data
Module 8 - Queries
Creating select queries
The query grid
Query criteria: Wild cards, comparison and logical operators
Summarising data in queries
Aggregate functions
Calculations in queries
Querying multiple tables
Join properties
Module 9 – Forms
Using an existing form
The form screen
Record navigation, Adding records
Creating a form using AutoForm
The form wizard, Mainform and Subform
Designing a form: labels and control sources
Selecting and moving, Resizing controls
Formatting controls, Using the toolbox
Conditional Formatting
Module 10 - Reports
Creating a report using the report wizard
Report bands, Designing reports
Creating and formatting controls
Grouping in reports, Calculating totals
Viewing a report in print preview
Printing reports |
4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk |
