Unit 2 Creating and Managing a Database

1. How do you start MS Access?

MS Access can be started from the Windows Start Menu.

2. What is a Blank Database?

A Blank Database is a new database created without predefined data or database objects. The user can create tables, queries, forms and reports according to their needs.

Example: For a school, we can create a database named School.accdb. This database can later contain tables such as Students, Teachers, Fees, Library, etc.

3. What is the default file extension of an Access 2007 database?

.accdb

4. How to Create a Blank Database?

• Open Microsoft Access.
• Click Blank Database.
• In the File Name box, type the name of the database (School.accdb).
• Choose the location where you want to save the database.
• Click the Create button.

NB: Give the database a meaningful name. Do not use space or special characters in the file name. Save it in an appropriate folder and remember the location.

5. How to Save a Database?

Type the name of the database in the File Name box. Choose the location. Click the Create Button.

6. What is a Table Template?

A Table Template is a ready-made table structure containing predefined fields.

7. How to create a Table using Templates?

• Open Microsoft Access. (You will see a blank database and some Templates such as Students, Contacts, etc.)
• Click on Template, Contacts.
• In the File Name box, type the name of the database (Contacts.accdb).
• Choose the location where you want to save the database.
• Click the Create button.

8. How to close MS Access?

• File → Close
• Click the Close (×) button at the top-right corner of the Access window.