Microsoft Access 2003 Tutorial By Juan Y 7

Microsoft Access 2003 Tutorial By: Juan Y 7

What is Microsoft Office Access? Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. ore? M e e s o t t n a W

When Do we Need MS Access? When do I need Access? l l l When you want to keep track of not only who’s on your guest list, but where they’re staying, and any dietary needs. When you need to be able to collect contact information accurately from large groups. When you want a database that is easy for colleagues to explore your information without training. When you need to run the same report daily, weekly, or monthly. When you want to know who your most valuable customers are so you can target your marketing.

How To Run Your Program? l l l First, Turn On Your Computer Then, Click Start or Simply Press The Start Button On Your Keyboard. Click All Programs Click File Microsoft office Click Microsoft Office Access 2003

How To Make A Database? l Click New on Toolbar l Save wherever you want l Click Blank Database on the Right Tab/bar l Click Create l Follow The Database Wizard instruction

What Is A DATABASE? ? ? What is a database? Quite simply, it's an organized collection of data. A database management system (DBMS) such as Access, File. Maker Pro, Oracle or SQL Server provides you with the software tools you need to organize that data in a flexible manner. It includes facilities to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports summarizing selected contents.

Knowing All The Tab l l l l Tables Tab : Hold The Raw Data. Queries Tab : Extract Part of The Raw Data To Produce Dynasts. Form Tab : Displays Data On-Screen for Viewing Or Editing. Reports Tab : Prints Data On Paper, Using Data From Tables. Pages Tab : Displays Data On A Web Browser. Macros Tab : Response To Events. Modules Tab : Visual Basic For Applications. Favorites Tab : Group Your Work To The Favorites.