Microsoft Office Tutorials and References
In Depth Information
Access 2010 database types
Access 2010 database types
Access 2010 has two types of databases: standard (“desktop”) and Web. The exercises in this
lesson involve the standard database type. A web database can be managed and viewed within
a web browser, and requires that the host computer is running Server software. For Access,
this would be SharePoint server. Users can use a web database in a web browser window,
but you would still use Access 2010 to make design changes. This is dif erent from a desktop
database which stored locally on your computer or within your business network. A desktop
database can be used and viewed on desktop machines, not over the Web.
Creating a simple database
In Lesson 1, you explored a database. Now you will create one. Access 2010 has two methods
for creating a database:
You can use one of the templates provided with Access 2010. A template is a database
that contains several objects (such as tables, forms, and reports) needed to execute a
particular task.
Even if a database is created from a template, you’re not required to use objects as they are
provided. Access 2010 allows you to customize objects. For example, if you feel that you have
a better design for a form, or you need a dif erent i eld name for a table (or a new table or
two), you can make your own customizations.
You can create a database from scratch, which is generally better suited for simple
databases, expert users, or when you cannot locate a suitable template.
It is far likelier that your job will entail working on an existing Access database.You will probably
enter information into the database and perhaps also be asked to edit or create database objects,
such as forms, tables, and queries.
Search JabSto ::




Custom Search