Jump to Step 1. Set up the sample Access database. You can access the sample database file, tutorial.accdb, in the folder returned by entering this code at the command line. For example, beginning in Access 2007, the software.
![]() Lesson 1: Getting Familiar with Microsoft Access 2007 for Windows
Microsoft Access is a database software package. A database is an organized collection of records. Telephone and address books are examples of paper databases. With Access, you can create a computerized database. For example, you can use Access to organize the students who attend a school, the courses they take, and the instructors who teach them. After you create an Access database, you can search it, manipulate it, and extract information from it. This lesson introduces you to Access windows and teaches you how to create a database.
Getting Started
You use windows to interact with Access. To begin, start Access 2007. You screen will look similar to the one shown here.
Northwind is a sample database you can download from the Microsoft website. I will use the Northwind database to introduce you to Access windows. If the Northwind database is already on your system, open it, otherwise download it and then open it.
To open Northwind:
To download Northwind, connect to the Internet and then follow these steps:
Understanding Security
It is possible for an Access database to contain malicious code, such as a computer virus. Access has security settings that disable code and display a security warning when you open a database. If you know a database is trustworthy, you can perform the following steps to enable it. You may need to enable the Northwind database.
To enable a database:
If you know a database is safe, you can store it in a trusted location. Databases stored in trusted locations do not require you to enable security.
To create a trusted location:
The Navigation Pane
The Access window used in this example has been set up to make it easier to explain. This section shows you how to set up your window so that it matches the example. If you are not already logged in to Northwind, click the Login button.
An Access database consists of the following objects: tables, queries, forms, reports, macros, and modules. The Navigation pane displays the objects in a database.
![]() To manipulate the Navigation pane:
In this example, the objects are organized by type, which is not the default setting. You may want to organize the objects in your database by type also. You can use the down-arrow on the top of the Navigation pane to change the manner in which objects are organized.
To organize objects by type:
The Access window with the Northwind database open is shown here.
![]()
Note: Your window probably does not look exactly like the one shown. In Access 2007, the window display depends on the size of the window, the size of your monitor, and the resolution to which your monitor is set. Resolution determines how much information your computer monitor can display. If you use a low resolution, you can fit less information on your screen, but the size of your text and images are larger. If you use a high resolution, you can fit more information on your screen, but the size of the text and images are smaller. Also, you can use settings in Access 2007, Windows Vista, and Windows XP to change the color and style of your windows.
The Microsoft Office Button
In the upper-left corner of the Access window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.
The Quick Access Toolbar
Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access toolbar provides you with access to commands you frequently use. By default, Save, Undo, and Redo appear on the Quick Access toolbar. You use Save to save an object, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back.
The Title Bar
The Title bar is located at the top in the center of the Access window. The Title bar displays the name of the database on which you are currently working.
The Ribbon
You use commands to tell Access what to do. In Access 2007, you use the Ribbon to issue commands. The Ribbon is located near the top of the Access window, below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab displays related command groups. Within each group are related command buttons. You click buttons to issue commands or to access menus and dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a group. When you click the dialog box launcher , a dialog box makes additional commands available.
Access ObjectsTo view or hide the objects on the Navigation pane:
As stated earlier, the Navigation pane stores the objects in your database: tables, queries, forms, reports, macros, and modules. Objects always display with an icon to the right. The icon tells you the object type: table, query, form, report, macro, and module.
You double-click an object to open the object. You right-click an object to view a menu of options. You can use the menu to do such things as open objects, rename objects, and delete objects.
Objects that are open appear on tabs. Right-click a tab to view a menu of options you can perform, such as save the object, close the object, or change the view.
Change Views
A view is a way of looking at an object. For example, in Access, data is stored in tables. Two of the possible ways you can view a table are Datasheet view and Design view. You can see the data contained in a table in Datasheet view. You can see the design of a table in Design view. When you open an object, buttons appear in the lower-right corner of the Access window. You can use the View button on the Home tab to change views, or you can click the proper button in the lower-right corner of the window.
Close a Database and Exit Access
This completes the introduction to Access using the Northwind database. The following describes how you close a database and exit Access.
To close a database:
To exit Access:
Create a Database
When you start Access, the Getting Started With Microsoft Office Access screen appears. You can use this screen to create a database. Within a database, you can do such things as enter data, create reports, and retrieve data. You can create a blank database or you can use one of the templates provided by Microsoft. When you use a template, Access creates forms you can use to enter data, reports you can use to retrieve data, and more. You can modify the forms, reports, and other objects to suit your needs. This tutorial will teach you how.
The following templates are included with Access: Assets, Contacts, Events, Faculty, Issues, Marketing Projects, Projects, Sales Pipeline, Students, and Tasks. Other templates are available online. Each template creates a database related to the title. For example, the Faculty template creates a faculty database that includes tables, queries, forms, and reports related to faculty. In Access, you use tables to store data, queries to retrieve data, forms to enter data, and reports to display data.
To use a template to create a database:
How do I create a database based on the templates that are found online?
Online templates fall into the following categories: Business, Education, Personal, and Non-profit. To create a database based on one of these templates:
How do I open an existing database?
Tip: You can also open an existing database by pressing Ctrl-O and then following steps 3 through 5.
Create a Blank Database
A blank database is a database with nothing in it. You must create all the tables, forms, reports, queries, and so on. If you cannot find a template that suits your needs, create a blank database. After you create the database, Access opens to a datasheet and makes available the tools you need to create objects. Creating tables is the first step in building a database. You will learn more about creating tables in the next lesson.
To create a blank database:
Note the Table Tools in the upper-right portion of the Ribbon.
What is a Datasheet? In Access, data is stored in tables. A datasheet displays the information stored in a table in columns and rows. The columns are called fields and the rows are called records. You can use a datasheet to create a table, enter data, retrieve data, and perform other tasks. ![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |