Wednesday, January 8, 2014

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.

Microsoft Access design:



1) Primary key.

2) Builder.

3) Validation Rules.

4) Insert Rows.

5) Delete Rows.

6) Lookup Columns.

7) Property sheet.

8) Indexes.

Design view you would be able to view

1) Field Name.

2) Data Type.

3) Description.

Field Properties:

1) General.

2) Lookup.

Please visit again for further updates.

Employment