Ms Access

Only available on StudyMode
  • Download(s) : 49
  • Published : March 31, 2010
Open Document
Text Preview
1

MS-Access 2007
The new look of Access 2007 Before starting the main part of the tutorial, we are just going to familiarize ourselves with the new look Access 2007 User Interface - or Access Screen. The Access Screen The Access 2007 Screen is very different to that in previous versions. The menus have been replaced by the Access 2007 Ribbon; there is the MICROSOFT OFFICE BUTTON instead of the old file menu; and the old database window has been replaced by the Access 2007 NAVIGATION PANE. There is also a GETTING STARTED screen to create or open a database file when Access is launched.

Access Ribbon

The ACCESS RIBBON works somewhat differently to the old Access Menus. There is a row of ribbon tabs with headings such as HOME, CREATE, EXTERNAL DATA, and DATABASE TOOLS. Clicking on each tab presents you with its own individual ribbon with its own particular icons. Each icon on a ribbon is contained within a group of icons that perform similar tasks. So, for example, the Create tab has groups for TABLES, FORMS, REPORTS and OTHER

MSAccess2007 - www.neteffect.in

2
Microsoft Office Button

The MICROSOFT OFFICE BUTTON is in the top left corner of the Access screen. It replaces the old Access file menu. So to perform functions such as saving, opening, new file creation, and printing etc, you need to click this button. To the right of this button is the Quick Access Toolbar intended to provide you with quick access to some of the more common commands used in Access 2007. There are three default icons on this toolbar - save, undo and redo. You can also customise this toolbar to add additional commands as required. Access Navigation Pane The Access NAVIGATION PANE replaces the old database window. It is here where you will see the icons for all the tables, forms, queries and reports that you create. When you want to open one of your database "objects", you just click on one of these the icons, and the required object will open in the main Access window.

Getting Started We will now move onto the first tutorial lesson where the Getting Started Screen will be introduced. Create Access 2007 Database The first step in creating an Access 2007 database, is to create a blank database file. This is done from the Getting Started Screen when you launch Access. The file is saved onto one of your PCs folders (which you specify). The procedure for doing this is outlined below.

MSAccess2007 - www.neteffect.in

3
1. Launch Access To begin, launch Access by clicking on the desktop icon, or choose Access from the start menu. This brings up the GETTING STARTED WITH MICROSOFT OFFICE ACCESS screen.

2. Select Blank Database Template

Towards the top left of the screen you will see a "Blank Database" icon. Click this icon to bring up the Blank Database side bar on the right hand side of the screen. This is where you will enter details about the database file that you are about to create. 3. Enter filename for your Access 2007 database

MSAccess2007 - www.neteffect.in

4
Begin by entering the name that you want to call the database in the filename textbox. 4. Browse and select folder Next click the folder icon and browse for a folder to put your database. Once selected you should see the file path below the textbox. 5. Click Create All you need to do now is click the "Create" command button below, and your database file saves to the location that you specified, and opens for you to work on. You are now ready to work on your newly created database file. The next step is to create an Access table Access 2007 tables

How Access stores data in Tables Like all other databases, Access 2007 stores data in tables. They look a lot like the cells of a spreadsheet with columns and rows. Each horizontal column represents a table record, and each vertical column represents a table field. See Table example below: A simple Table ID Number 1 2 3 FirstName John Tracey Anne Surname Jones Smith McNeil Age 35 25 30

In the example...
tracking img