Labguide Create Database

BIS2024 Business Information Systems

T2 2011/12 :: Faculty of Business & Law

1

Lab#1 Introduction to MS Access 2010, Table Creation

& Relationship

At the completion of this lab session, you will be able to: - Start Access - Identify parts of the Access screen - Select objects in the Database window - Create tables - Create fields in table - Customize field properties: format/data type/input mask/default value/validation rule/validation text - Close a database and exit Access 1. Create relationship between tables -

 What is MS Access?

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.

 When do we use MS Access?

You should consider building your database with Microsoft Access if your data structures can be represented by the relational model. This is true of most business applications, Microsoft Access can be used for quite large, complex database applications. If you frequently need to send out mail shots then Microsoft Access is particularly suitable for use with the mail merge tool in Word.

1

 Getting Started

You use Windows to interact with Access. To begin, start Access 2010. Your screen will look similar to the one shown here.

 Create a Database

In Access, all the tables, queries, forms and reports that you create are stored in a single file called a database. Thus, you must first create the database to hold the tables, queries, forms and reports. You can use either the Blank database option or a template provided by Microsoft to create a new database. When you use a template, Access creates forms you can use to enter data,...