Microsoft Access supports many ways of using, interpreting, or applying the SQL.Ĭode based on SQL is referred to as a SQL statement. The SQL is equipped with keywords that tell it what to do and how to do it.

Also, in these lessons, we will regularly write, 'The SQL' instead of 'The SQL language', as the L already represents Language.Īs it is common with other computer languages, the SQL has with its syntax, vocabulary, and rules. For this reason, the abbreviation will always be considered as a word, which would result in 'A SQL statement' instead of 'An SQL statement'. In our lessons, we will consider the Sequel pronunciation. Is called the structured query language, or SQL.

The primary language to perform the operations on a database Sections depend on what is currently going on in Microsoft Access: Under the title bar, Microsoft Access displays a long bar called the Ribbon (or ribbon), whose contents and To return to the previous window, you can click You can access menu items to save or open one: To assist you with necessary operations, Microsoft Access is equipped with the Ribbon. The left side of the title bar displays the Quick Access Toolbar

In the right section of the screen, set the File Name to Exercise1.

In the middle section, click Blank Desktop Database.

In the dialog box, specify the desired name of the file and click Create. To start with a project from scratch, you can click Blank Desktop Database. The right side displays a list of example databases. The left side displays a list of previously used files. When it starts, Microsoft Access displays two sections: As is the case for every application, to use Microsoft Access, you must launch it, which is done from the menu on the Start button of Microsoft Windows. Microsoft Access is is equipped with all the tools you will need to start a project, to end it, and to distribute it. Practical Learning: Starting Microsoft Access Microsoft Access is an application used to create and A computer database is a list or a group of lists stored in a computer disc such as a hard drive. VBA Tutorials - Lesson 01: Introduction to Microsoft Access and VBAĪ database is a list of values stored somewhere.

Microsoft access 2013 tutorial pdf