Wednesday, January 8, 2014

Microsoft access 2007 datasheet.


Views:

a) Datasheet view

b) Design view


Fields & Columns

a) New Field

b) Add Existing Fields

c) Lookup Column

d) Insert

e) Delete

f) Rename


Data Type & Formatting

Data Type

Format

Apply Currency Format

Apply Percent Format

Apply Comma Number Format

Increase Decimals

Decrease Decimals


Relationships

a) Relationships

b) Object Dependencies

 Please do visit for further updates.

Employment.

Microsoft access additionals.

Menu Commands.

1) Send to Bluetooth.


Please do visit us again for further updates.

Employment.

Microsoft access data parameters.

External Data

Import

a) Saved Imports

b) Access

c) Excel

d) SharePoint List

e) Text File

f) XML File


Export

a) Saved Exports

b) Excel

c) Sharepoint List

d) PDF or XPS

e) Word

f) Text File


Collect Data

a) Create E-mail.

b) Manage Replies



SharePoint Lists

a) Work Online.

b) Synchronize.

c) Discard Changes.

d) Cache List Data.

e) Relink Lists.

f) Move to SharePoint.

Please do visit for further update.

Employment.

Create microsoft access sheet.

Tables.

a) Table

b) Table Templates

c) SharePoint Lists

d) Table Design


Forms

a) Form

b) Split Form

c) Multiple Items

d) Pivot Chart

e) Blank Form

f) Form Design


Reports:

a) Report

b) Labels

c) Blank Report

d) Report Wizard

e) Report Design

Other:

a) Query Wizard

b) Query Design

c) Macro

Please do visit for further update.


Employment.


Microsoft access parameters.

MS-Access tools

        Home

1) View
 
    a) Datasheet view

    b) Design view

                                                   2) Clipboard

                                          a)  Paste
  
                                          b)  Paste Special

                                         c)  Paste Append

                                         d) Cut

                                        e) Copy

                                        f) Format Painter

3)  Font

a) Font Face

b) Font Size

c) Align Text Left

d) Align Text Right

e) Center

f) Bold

g) Italic

h) Underline

i) Font Color

j) Fill/Back Color

K) Gridlines

L) Alternate Fill/Back Color


                                                   Rich Text:

                                         a) Decrease List Level

                                        b) Left to Right Text Direction

                                        c) Numbering

                                        d) Text Highlight Color


Records:

a) Refresh All

b) New

c) Save

d) Delete

e) Totals

f) Spelling

g) More


                                                        Sort & Filter

                                                       a) Ascending.

                                                       b) Descending.

                                                       c) Clear all Sorts.

                                                      d) Filter.

                                                      e) Selection.

                                                      f) Advanced.

                                                      g) Toggle Filter.


Find

a) Find.

b) Replace.

c) Go To.

d) Select.

Please do visit for further update.

Employment.

Tuesday, January 7, 2014

Microsoft access tools.

Database.

1) Visual Basic
  
     a) Run Macro

     b) Convert Report`s Macros to Visual Basic

2) Relationships
 
    a) Property Sheet

    b) Object Dependencies

3) Analyze

    a) Database Documenter

    b) Analyze Performance

    c) Analyze Table

4) Data

   a) SQL Server

   b) Access Database

5) Database Tools

   a) Switchboard Manager

   b) Encrypt with Password

   c) Add-ins

      c(i) Add-in Manager

   d) Make ACCDE.

Please do visit for further update.
  
Employment.
   

Microsoft scripting language.

Microsoft Visual Basic :-

1) File

2) Edit

3) View

4) Insert

5) Debug

6) Run

7) Tools

8) Add-Ins

9) Windows

10) Help.

Please do visit for further update.

Employment.