Getting
Started with 2010
Using the Ribbon instead of menus
The Quick Access Toolbar
Command Tabs
Contextual Command Tabs
Microsoft Back Office replaces the File menu
Customise the Ribbon!
Querying
Crosstabs
Parameters
Calculated
Totals
Action Queries
Make table
Append
Delete
Update
Multiple
Table Queries
Joining tables
Types of joins
Relationships Vs Joins
AutoLookup Query
Relationships
Understanding relational databases
Types of relationships
1-1
1-Many
Many-Many
Bridging tables
Book Now or Enquire
|
Forms
Using expressions
Inherited filters
Subforms / subreports
Grouping and sorting data
Object
Linking and embedding
Adding a picture / object
Editing objects
drag and drop database objects
Protecting
data
Valadating data entry
Setting passwords
Hiding objects
Introduction to database sucurity
Creating
and using macros
Creating
Editing
Running
Grouping
Conditional macros
Creating
a database application
Using forms
Autostart-ups
Hiding windows options
Creating buttons
New Features of Access 2010
New General Features
Getting Started Window
Navigation Pane
Status Bar
Tabbed documents
File Type
Help
Security
Formatting
New Table Features
Sorting and Filtering
Field Enhancements
Data Type Recognition
Datasheet Total Row
Adding Fields
New Form and Report Features
Quick Create
New Layout Views
New Report View
Split Forms
Group and Sort
Stacked and Tabular Layouts
New Integration Features
Import and Export Wizards
Data Collection
SharePoint Services
Book Now or Enquire
|
