Cargando…
Mos 2013 study guide for Microsoft Access /
Designed to help you practice and prepare for the 2013 Access Microsoft Office Specialist (MOS) exam, this all-in-one study guide features: full, objective-by-objective exam coverage; easy-to-follow procedures and illustrations to review essential skills; hands-on practice tasks to apply what you�...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Redmond, Wash. :
Microsoft Press,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover ; Copyright page ; Contents; Introduction; Who this book is for; How this book is organized; Download the practice files; Sidebar: Adapting exercise steps; Ebook edition; Get support and give feedback; Errata; We want to hear from you; Stay in touch; Taking a Microsoft Office Specialist exam; Microsoft Office Specialist certification; Selecting a certification path; Test-taking tips; Certification benefits; For more information; Exam 77-424: Microsoft Access 2013; Prerequisites; Objective 1: Create and manage databases; 1.1 Create new databases; Creating desktop databases.
- Creating Access web appsWorking with application parts; Using earlier Access file formats; Practice tasks; 1.2 Manage relationships and keys; Specifying primary keys; Setting and viewing relationships; Practice tasks; 1.3 Navigate through databases; Working with Access views; Finding records; Configuring the Navigation pane; Building navigation forms; Practice tasks; 1.4 Protect and maintain databases; Compacting and repairing databases; Encrypting database files; Backing up databases; Restoring data from a backup; Merging Access databases; Splitting databases; Practice tasks.
- 1.5 Print and export databasesPrinting in Access; Working in Print Preview; Exporting data; Saving databases as templates; Using the Save Database As options; Practice tasks; Objective review; Objective 2: Build tables; 2.1 Create a table; Defining tables in Design view; Creating tables in Datasheet view; Importing data into a table; Sidebar: Creating an import spec; Sidebar: Importing data from other formats; Using linked tables; Creating tables in Access web apps; Practice tasks; 2.2 Format tables; Hiding fields in tables; Changing data formats; Adding a Total row.
- Adding table descriptionsRenaming tables; Practice tasks; 2.3 Manage records; Adding, updating, and deleting records; Appending records; Finding, sorting, and filtering data; Practice tasks; 2.4 Create and modify fields; Adding and deleting fields; Working with field properties; Sidebar: Other field properties available in Datasheet view; Changing field data types; Sidebar: Configuring fields to auto-increment; Using input masks; Practice tasks; Objective review; Objective 3: Create queries; 3.1 Create a query; Running queries; Saving and deleting queries; Creating select queries.
- Creating parameter queriesCreating action queries; Viewing data in a crosstab query; Sidebar: Union, pass-through, and data definition queries; Managing multiple tables and joins; Practice tasks; 3.2 Modify queries; Changing the fields in a query; Showing and hiding query fields; Specifying the sort order for queries; Formatting fields in a query; Practice tasks; 3.3 Utilize calculated fields and grouping within queries; Grouping and summarizing query records; Sidebar: Creating custom field names; Using calculated fields; Using operators in query criteria and expressions.