Microsoft Access 2007, hereinafter referred to as Access 2007
is a database application program is popular and widely used
at this time. With Access 2007 you can design, create,
and manage the database easily.
Access 2007 has the appearance of the user interface (UI) which
changing menus, toolbars, and task panes that most of the existing
in previous versions of Microsoft Access with a single mechanization
more simple and efficient. User interface (UI) is designed for new
help you work more productively and easy to use
all facilities and functions.
Database components:
1. Tables: a collection of data as a key component in the database.
2. Queries: function to filter data from multiple criteria and the order in which
desired.
3. Forms: data entry work, data display and edit data from
a table with a view fomulir we have designed themselves.
4. Reports: function print data in a report.
5. Pages: function creating web pages in the form of data access pages.
6. Macros: mengotomastiskan function commands that we want in
process data.
7. Modules: functions for designing a variety of application modules in
advanced database processing according to what we want.
Data Types in Access
Text
On this data type is the type of data stored character. The maximum length of field type
is 255 characters which is the default type.
memo
On this data type, the type of data that is stored is the character. The maximum length of field type
is 65,535 characters.
Number
Is a data type used to contain numeric data type.
Date / time
The type of data is the data stored with the date and time of the 8 bytes of memory.
currency
Is a data type that is used to store the number in currency format.
The amount of storage memory is 4 bytes.
Auto Number
This data type is used to provide automatic numbering (adding numbers
automatic)
Yes / No
This data type contains the data Yes or No, True or False, Yes or No.
OLE Object
This data type can load images, graphics, video and sound with a maximum size of 1 GB
(upper limit of the hard drive)
hyperlink
Data type that contains URL hyperlink address with a maximum length of 64,000 characters.
Lookup Wizard
Data types that are used to display data from another table. large memory
generally 4 bytes of storage.
To start a program or open a Access 2007 application, follow
the following steps:
1.Nyalakan your computer, wait until the computer displays
working area (desktop) Microsoft Windows XP Service
Pack (SP) 2, Microsoft Windows Server 2003, or Microsoft
Windows Vista.
2.Click the start button on the taskbar.
3.Pilih menu or click All Programs> Microsoft Office>
Microsoft Office Access 2007.
COMPONENT ACCESS 2007
Before you further learn Access 2007, you should first know about the components to facilitate pengoprasian.
1. Office Button
Button that holds frequently used menu commands in access among others; New, Open, Save, Save as, Close, Database and other commands.
2. Quick Access ToolBar.
A set of keys to perform certain commands in Access mengoprasikan 2007.misal; Save, Undo, Redo.
3. Title Bar Serves to show name of the program window, but it serves to select the position of the program window.
4. Minimize Tool To minimize the Access 2007 program window so the display turns into an icon that is placed on the Windows XP taskbar.
5. Maximixe Tool Serves to maximize the size of the program window, so tampilanya meet the screen.
6. Close Tool serves to close the window or exit the program Access 2007
7. Status Bar is used to display the current status of program worksheets Access 2007 for example; Caps Lock, Num Lock, Scroll Lock.
although it does not display the menu bar you can also be able to use the / dialog button located on each - individual or group can also use the Shortcut menu (popup menu) is also using the Shortcut Key (eg Ctrl + S) ..
Tidak ada komentar:
Posting Komentar