Objective 1.1 Create and modify databases

  • 1.1.1 Create databases
  • 1.1.2 Import database objects and data
  • 1.1.3 Delete database objects

OBJECTIVE 1.1: Contents

  • 1.1.1 Create databases
  • 1.1.2 Import database objects and data
  • 1.1.3 Delete database objects

When you start Access without opening a recently used database or double-clicking a database file, the program opens to its startup screen. The startup screen displays a list of recent files and a set of thumbnails for templates on which you can base a variety of desktop databases or Access web apps (a type of database stored in the cloud). Access also provides an option for creating a blank desktop database or a custom (blank) web app.

Screenshot of the Task Management desktop database.

Database templates such as the Task Management template provide a set of database objects you can build on

This topic provides details about how to create a blank desktop database, how to create a database from a template, how to import data to build a database, and how to delete a database object.

Tip: On the General page of the Access Options dialog box, you can set options for the default file format for a blank database and the default database folder.