Access 2007 Concepts
- What is a Database?
- What is a Relational Database?
- What is a Table?
- What is a Record?
- What is a Field?
- What is Data?
- Data Types
First Look at Access 2007
- Exploring the Access 2007 Window
- Using the Ribbon
- Ribbon Tabs and Groups
- The Dialog Box Launcher
- Navigation and Keys
- Contextual Tabs
- Minimising the Ribbon
- Quick Access Toolbar
- The Office Button
- Access Help
Opening a Database and Security
- Opening a Database
- Security Warnings
- Trusted Locations - Trust Centre
- Setting the Default Folder Location
|
Creating Databases and Using Views
- Creating a New Database
- Saving a Table
- Adding and Renaming Fields
- Using Different Views
- Changing the Views
Table Modification and Navigation
- Adding Fields - Design view
- Data Types
- Using the Attachment Data Type
- Adjusting Column Width
- Moving a Column to Rearrange the Column Order
- Adding Records to a Table
- Navigating Through Records within a Table
- Closing a Database
- The Navigation Pane
Field Properties, Validation and Input Masks
- Field Properties
- Input Masks
- Using Validation Rules
- Field Properties - Using Guide Tables
|
Manipulating Records and Tables
- Closing an Object
- Renaming an Object
- Editing and Deleting Data within a Record
- Using the Undo Command
- Deleting a Single Record
- Deleting Multiple Records
- Save as - Database Objects
- Deleting a Table
Primary Keys and Indexing
- Defining a Primary Key
- Indexing
- Creating a Single Field Index
- Creating a Multiple Field Index
- Deleting Multi Field Indexes
Filtering and Sorting
- Text filters
- Applying a Single Filter
- Clearing a Single Filter
- Creating Multiple Filters
- Clearing Multiple Filters
- Sorting
|
