Microsoft Access 2003.

Uploaded on:
Category: Food / Beverages
Microsoft Access 2003 A Couple Expressions Database - a gathering of related data. Object - a thing in the database, for example, a table, question, structure, or full scale. Table - a gathering of related information sorted out in fields (sections) and records (columns) on a datasheet. A Couple Expressions
Slide 1

Microsoft Access 2003 ICS 014 – 042 Yazdani

Slide 2

A Few Terms Database - a gathering of related data. Object - a thing in the database, for example, a table, inquiry, structure, or full scale. Table - a gathering of related information sorted out in fields (segments) and records (columns) on a datasheet.

Slide 3

A Few Terms Field - a section on a datasheet and characterizes an information sort for an arrangement of qualities in a table. Record - a line on a datasheet and is an arrangement of qualities characterized by fields. Configuration View - gives the devices to making fields in a table. Datasheet View - permits you to upgrade, alter, and erase in development from a table.

Slide 4

Creating a New Database To make another database, click on Create another file…

Slide 5

New File Selections

Slide 6

To Create a New Database Option 1 – Blank Access Database Creates another clear database. In the wake of selecting "Blank Access database", you will first be incited to determine an area and name for the database. You must spare an Access database before you begin chipping away at it.

Slide 7

Find the organizer where the database ought to live in the Save in drop-down menu. Sort the database\'s name in the File name line and snap the Create catch.

Slide 8

To Create a New Database Option 2 – Blank Data Access Page Creates another clear Data Access Page. An information access page is an uncommon sort of Web page intended for survey and working with information from the Internet or an intranet that is put away in a Microsoft Access database. The information access page might likewise incorporate information from different sources, for example, Microsoft Excel.

Slide 9

Data sources can be different Access databases, different sorts of databases, Excel spreadsheets, or a Microsoft Data Link.

Slide 10

Data Access Pages Data access pages have the accompanying points of interest over printed reports: Pages bound to information show current information in light of the fact that they are associated with a database. Pages are intelligent. Clients can channel, sort, and view only the records that they need. Pages can be dispersed electronically by utilizing email. Beneficiaries will see current information every time they open the message.

Slide 11

To Create a New Database Option 3: Project utilizing existing data… Creates a database from a current Microsoft Office Access Project. Skim to a current Microsoft Access Project and snap OK . Name the database on the following screen.

Slide 13

Microsoft Access Projects A Microsoft Access venture (.adp) is an Access information document that gives local mode access to a Microsoft SQL Server database through the OLE DB part construction modeling. Utilizing an Access venture, you can make a customer/server application in view of structures and reports, or a Web-construct arrangement based with respect to information access pages , or a mix of both. You can unite the Access undertaking to a remote SQL Server database, a nearby SQL Server database, or a neighborhood establishment of SQL Server 2000 Desktop motor.

Slide 14

To Create a New Database Option 4: Project utilizing new data… Creates another Microsoft Office Access Project to construct another Access Database with respect to. Peruse to a current information source or snap on the make catch.

Slide 16

To Create a New Database Option 5: From existing file… Creates another database from a current Access database, a Microsoft Access Project, or a page. Search to the record you wish to utilize.

Slide 18

To Create a New Database Option 6: From a format Creates another database from a current layout on you\'re PC or from Microsoft Online. Fastest approach to make a database. This technique works best in the event that you can discover and utilize a format that intently coordinates your prerequisites.

Slide 20

Opening a current database If the database was opened as of late on the PC, it will be recorded in the right window. Highlight the database name and snap OK .

Slide 21

Opening a current database Otherwise, highlight "More..." From the consequent window, tap the "Look In:" drop-down menu to discover the organizer where the database is found, highlight the database name in the posting and snap OK .

Slide 22

Opening a current database

Slide 23

Database Window The Database Window composes the greater part of the articles in the database. The default tables posting gives connections to making tables and will list the greater part of the tables in the database when they have been included.

Slide 24

Menu Bar Office Links Relationships Analyze Properties New Object

Slide 25

Design View Design View alters the fields in the database with the goal that information can be entered.

Slide 26

Indexes Primary Key Design Sheet/View Toggle Field Builder Primary Key Marker Insert/Delete Rows Database Window

Slide 27

Datasheet View The datasheet permits you to enter information into the database

Slide 28

Sorting Filtering Find Design Sheet/View Toggle Record Selector Navigation Buttons & Record Number New Record Delete Record

Slide 29

Introduction to Tables are networks that store data in a database like the way an Excel worksheet stores data in an exercise manual. Access gives three approaches to make a table for which there are symbols in the Database Window. Double tap on the symbols to make a table.

Slide 31

Introduction to Tables Create table in Design perspective will permit you to make the table\'s fields. This is the most widely recognized method for making a table.

Slide 32

Create a Table in Design View Design View will permit you to characterize the fields in the table before adding any information to the datasheet. The window is isolated into two sections: a top sheet for entering the field name, information sort, and an alternative portrayal of the field a base sheet for determining field properties.

Slide 33

Indexes Primary Key Design Sheet/View Toggle Field Builder Primary Key Marker Insert/Delete Rows Database Window

Slide 34

Introduction to Tables Create table utilizing wizard will step you through the formation of a table.

Slide 35

Introduction to Tables Create table by entering information will give you a clear datasheet with unlabelled sections that resembles an Excel worksheet.

Slide 36

Primary Key Every record in a table must have an essential key that separates it from each other record in the table. Can assign a current field as the essential key on the off chance that you are sure that each record in the table will have an alternate worth for that specific field. A government managed savings number is an illustration of a record whose qualities will just show up once in a database table.

Slide 37

Primary Key Designate the essential key field by right-tapping on the record and determination Primary Key from the alternate way menu or select Edit|Primary Key from the menu bar. The essential key field will be noted with a key picture to one side. To evacuate an essential key, rehash one of these strides.

Slide 38

Primary Key If none of the current fields in the table will deliver special qualities for each record, a different field must be included. Access will provoke you to make this kind of field the first occasion when you spare the table and an essential key field has not been alloted. The field is named "ID" and the information sort is “AutoNumber".

Slide 39

Primary Key The AutoNumber information sort naturally upgrades at whatever point a record is included so there is no additional deal with your part. This field fills no need to the client so you might likewise decide to conceal this section in the datasheet.

Slide 40

Datasheet Records Adding Records Add new records to the table in datasheet view by writing in the record next to the reference bullet (*) that denote the new record. You can likewise tap the new record catch at the base of the datasheet to skip to the last discharge record.

Slide 41

Sorting Filtering Find Design Sheet/View Toggle Record Selector Navigation Buttons & Record Number New Record Delete Record

Slide 42

Editing Records To alter records, basically put the cursor in the record that is to be altered and roll out the important improvements. Utilize the bolt keys to travel through the record network. The past, next, initially, and last record catches at the base of the datasheet are useful in moving through the datasheet.

Slide 43

Deleting Records Delete a record on a datasheet by putting the cursor in any field of the record push and select Edit|Delete Record from the menu bar or snap the Delete Record catch on the datasheet toolbar.

Slide 44

Introduction to Queries select records from one or more tables in a database so they can be seen, broke down, and sorted on a typical datasheet. The subsequent accumulation of records, called a dynaset (short for element subset), is spared as a database question and can in this manner be effortlessly utilized as a part without bounds.

Slide 45

Introduction to Queries The inquiry will be overhauled at whatever point the first tables are redesigned. Sorts of questions are select inquiries that concentrate information from tables taking into account determined qualities, discover copy questions that show records with copy values for one or a greater amount of the predetermined fields discover unmatched questions showcase records from one table that don\'t have relating qualities in a brief moment table.

Slide 46

Query Wizard Access\' Query Wizard will effortlessly help you to start making a select question. Click the Create inquiry by utilizing wizard symbol as a part of the database window to have entry step you through the procedure of making a question.

Slide 48

Query Wizard From the first window, select fields that will be incorporated in the question by first selecting the table starting from the drop Tables/Queries menu. Select the fields by tapping the > catch to move the field from the Available Fields rundown to Selected Fields.

Slide 49

Query Wizard Click the twofold bolt catch >> to move the greater part of the fields to Selec

View more...