MS Access-Microsoft Acess-Tutorial, Study Guides, Projects, Research of Microsoft Access Skills

Download MS Access-Microsoft Acess-Tutorial and more Study Guides, Projects, Research Microsoft Access Skills in PDF only on Docsity!

MS Access

 A database software package.

 A database is an organized collection of records.

Telephone and address books are examples of paper

databases.

MS Access

Microsoft Office Button

 The Microsoft Office

Button allows to create a

new database, open an

existing database, save

and save as, print, send,

or close.

MS Access

The Ribbon

 The ribbon is the panel at the top portion of the document It

has four tabs:

 Home

 Create

 External Data

 Database Tools.

 Each tab is divided into groups. The groups are logical

collections of features designed to perform function that you

will utilize in developing or editing your Access database.

MS Access

Quick Access Toolbar

 The quick access toolbar is

a customizable toolbar that

contains commands that you

may want to use. You can

place the quick access toolbar

above or below the

ribbon. To change the

location of the quick access

toolbar, click on the error at

the end of the toolbar and

click Show Below the

Ribbon.

MS Access

Navigation Pane

 The Navigation Pane displays database objects such

as tables, forms, queries, and reports.

MS Access

T A B L E

Q U E R Y

F O R M S

R E P O R T S

Concepts

Table

 A table is a collection of information arranged in

rows and columns. Information about an item is

displayed in a row. Columns contain the same type

of information for each item. The table has a header

row that tells you what data is contained in the

columns.

MS Access

Query

 Queries select records from one or more tables in a database so they can be viewed, analyzed, and sorted on a common datasheet. A query can also perform calculations and display the results.

 Types of queries are  select queries that extract data from tables based on specified values  find duplicate queries that display records with duplicate values for one or more of the specified fields  find unmatched queries display records from one table that do not have corresponding values in a second table.

 To run a query:  Click the arrow to open the navigation pane  Double-click on the query name

 Record set A record set is a table that displays groups of records from a base table or as a query result.

02/07/

MS Access

Form

 A form is a graphical

interface that is used to

display and edit data. Forms

can be developed from a

table or a query. Forms can

include calculations,

graphics and objects.

 To view data using a form:

 Click the arrow to open the

navigation pane

 Double-click on the form name

MS Access

Creating a New Database

 You can create a new database from scratch or you

can create a database from the database wizard.

 New Database

To create a new database from scratch:

 Click the Microsoft Office Button

 Click New

 Click the New Blank Database icon

MS Access

Database Templates

 To create a new database from the database

templates:

 Click the Microsoft Office Button

 Click New

 Choose the type of database you wish to create

MS Access

 Type in the name for the database

 Click Create

MS Access