Contents
· Module 1 : INTRODUCTION
· Module 2 : DATA TYPE
· Module 3 : TABLES
· Module 4 : QUERY
· Module 5 : FORMS
· Module 6 : REPORTS
· Module 7 : LABELS
· Module 8 : MACRO
· Module 9 : EXTERNAL DATA
· Module 10 : RELATIONSHIP
Introduction
- Introduction
- Interface
- Tabs and Ribbons
- Document Windows
- Navigation Tips
- Office Button and Save
DATA TYPE
- Data Type Property uses & Settings-
- Text
- Memo
- Number
- Date /Time
- Currency
- AutoNumber
- Yes/No
- OLE Object
- Hyperlink
- Attachment
- Lookup Wizard.
TABLES
- Create Table
- Templates
- Contacts
- Tasks
- Issues
- Events
- Assets
QUERY
- Simple Query Wizard
- Crosstab Query Wizard
- Find Duplicates Query Wizard
- Find Unmatched Query Wizard
Query Design
- Create Query
FORMS
- Columnar
- Tabular
- Datasheet
- Justified
Form Design
- Split Form
- Multiple Items
- Design View
- Layout View
REPORTS
- Columnar
- Tabular
- Justified
- Blank Report
- Design View
- Layout View
LABELS
- Create Label
Macros
- Macro Name
- Action
- Arguments
- Table / Query / Form /Report Name
- View-Datasheet, Design, Print Preview
- Mode- Add, Edit, Read Only
External Data
- Import Access Database
- Import Excel Spreadsheet
- Import Text File
- Import HTML Document
- Export to Excel Spreadsheet
- Export to RTF File
- Export to Text File
- Export to Access Database
- Export to HTML Document
RELATIONSHIP
- One-to-One Relationship
- One-to-Many Relationship
- Many-to-Many Relationship
No comments:
Post a Comment