MS Access Online Test


TEST YOUR KNOWLEDGE - SKILLS 

About MS Access - Introduction



Microsoft Access

Very simply, Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.

Extension = .mdb (Microsoft Data Base)

Microsoft Access is a Relational Database Management System (RDBMS), designed primarily for home or small business use.
Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports. When you create a database, Access offers you Tables, Queries, Forms, and Reports.

History of Access

In the late-1980s: Microsoft started developing its own database targeted for Microsoft Windows and OS/2. Mid 1992: Microsoft released a beta version of Cirrus, a database product. It was given the official name of Access. Late 1992: Microsoft released the first version of Access.

MS ACCESS INTERFACE (GUI)




ASCII CODES




ACCESS TERMS AND DEFINITIONS

Tables

Tables store raw data that is the backbone of the entire database system. Tables are often related to other tables in the file.

Forms

Forms display live data from the tables for data entry or editing. They are sometimes called “screens” or “user interfaces.”

Queries

Queries answer a question by selecting and sorting data for you based on what you want to know. For example, a query can tell you “how many open orders are there this month?”

Reports

Reports display data in pre-formatted templates for printing or display. Data cannot be edited in reports. It must be edited through data entry, prior to running the report.

DATE FORMATS:




Click Here for MS Access Form Samples



MS Access Queries:








 










MS ACCESS LOCAL & GLOBAL CERTIFICATIONS:

MS ACCESS YOUTUBE PLAYLIST:

Microsoft Access Basic Tutorial