Friday, March 14, 2014

Properties of 2007 MS Access database.

Database2.accdb properties.

Type of the document:Microsoft Office Access 2007 Database.

MS DOS Name:DATABA~2.ACC

Title: Title of the document.

Subject: Access database.

Author:

Manager:

Company: Foragers.

Category: Basic database.

Keywords:Microsoft access.

Comments: Microsoft access database.

Statistics: Saved by: Revision number: Editing time: Contents:

Tables:

Table1.
 a) Queries.
 b) Forms.
 c) Reports.
 d) Data access pages.
 e) Macros.
 f) Modules Custom: Name: Recorded table.

Reference Source Status Telephone number Typist. Type: Text. Date Number Yes or No. Properties.

Please do visit for further updates. 

Employment



Tuesday, March 11, 2014

Microsoft access data.



Microsoft Access is used for storing data information. Database of products and manuals is stored in Microsoft access. The way information could be stored is defined in Microsoft access.


Please do visit for further updates.

Employment.

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.