18  SQL in Access: Setup

18.1 Running SQL in Microsoft Access

• Open the database in MS Access

• Create a new Query: Create > Query Design

• Open the Query in SQL View: Query Design > View > SQL View

• Write the SQL statement: SELECT TOP 5 * FROM tblStudent

• Click Run button in the ribbon

In the following sections, a quick tutorial with images captures Tables (Table View and Design View) and Queries (Table View, SQL View and Design View) in Microsoft Access environment.

18.2 Tables: Table View

tblStudent in Table View

18.3 Tables: Design View

tblStudent in Design View

18.4 Queries: SQL

Query ‘SQL View’ from Ribbon

18.5 Queries: SQL More

Query ‘SQL View’ from Right Click

18.6 Queries: Datasheet

Query Datasheet View from Ribbon